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

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