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

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.

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

Why don't you do find replace?

"Question for excel file" wrote:

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.

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

hi
=substitute(A1,".",",")
regards
FSt1

"Question for excel file" wrote:

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.

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

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
wrote in message
...
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.

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

ToolsOptionsInternational.

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
wrote:

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.