Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number Format. Switch Comma to Dot
Hello,
I have the following number in a cell: 12,892.70 This is recognized as text. I tried to change the cell format to number and it does not work. The format should be 12.892,70. Is there a way to make this change on the Sheet instead of VB? Thanks, Miguel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number Format. Switch Comma to Dot
Select the cell or (contiguous) cells (in a column),click Data/TextToColumns
in the menu bar, click Next button twice, then click the Advanced button on the third dialog page and change the two separator characters to what you have (comma for decimal and dot for thousands), hit OK, select "General" in the "Column data format" section and click the Finish button. -- Rick (MVP - Excel) "shapper" wrote in message ... Hello, I have the following number in a cell: 12,892.70 This is recognized as text. I tried to change the cell format to number and it does not work. The format should be 12.892,70. Is there a way to make this change on the Sheet instead of VB? Thanks, Miguel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I center a number in "comma" format? | Excel Discussion (Misc queries) | |||
dates switch to general format | Excel Discussion (Misc queries) | |||
SWITCH NUMBER BY LETTERS | Excel Discussion (Misc queries) | |||
switch number order | Excel Worksheet Functions | |||
Number Switch Code | Excel Programming |