Number Format. Switch Comma to Dot

  • Thread starter Thread starter shapper
  • Start date Start date
S

shapper

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
 
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.
 
Back
Top