I WOULD LIKE TO CHANGE "." FOR "," IN EXEL FILE, CAN YOU HELP ME?

  • Thread starter Question for excel file
  • Start date
Q

Question for excel file

I am searching any formule or option to change "." for ",". I have receive a
document which show the decimals as "." and I need to change to "," to can to
add.
 
R

Rick Rothstein \(MVP - VB\)

Are there any dots in there that are not decimal points (for example, in
abbreviations such as Mr., Co., etc.)? Also, where do you want this change
to happen at? That is, have you loaded the file and want to change it within
the worksheet(s); or do you want the file itself changed?

Rick


"Question for excel file" <Question for excel
[email protected]> wrote in message
news:[email protected]...
 
G

Gord Dibben

Tools>Options>International.

Change the separator characters.


Gord Dibben MS Excel MVP

On Tue, 25 Mar 2008 12:31:06 -0700, Question for excel file <Question for excel
 
Top