| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comma replacement
I am in Europe. I use by default coma as decimal separator.
In a particular situation I need to replace the coma by point. I have this code: Columns("p:p").Select Selection.NumberFormat = "General" Selection.Replace What:=",", Replacement:="." But nothing is happening. Column P still has comma as decimal separator. What am I doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract the text between last comma and last but one comma. | Excel Worksheet Functions | |||
| Using comma inside the comma delimited text in Data Validation/Sou | Excel Programming | |||
| Comma Delimited-need comma at beginnng & end | Excel Discussion (Misc queries) | |||
| Replacement | Excel Programming | |||
| Excel How do I create a comma delineated xls file to a comma delineated. | Excel Discussion (Misc queries) | |||
Threaded Mode
