Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, can you help me?
I need replace dot (.) to comma (,) in worksheet cells. The number format is "123 456,00" in my international settings. Another application export numbers as "123.1234" format, but Excel knows the number as "123,1234" format. The cells a 34.2444 0.5687 97.7290 0.8474 34.2677 0.5689 97.7180 0.8067 ... The Selection.Replace What:=".", Replacement:="," ... command replace these cells as: 342 444 0,5687 977 290 0,8474 342 677 0,5689 977 180 0,8067 but I need as: 34,2444 0,5687 97,7290 0,8474 34,2677 0,5689 97,7180 0,8067 Thank you your time |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
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 |