Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
=IF(D13="PAID","YES","NO") Can I change fonts colour | Excel Discussion (Misc queries) |