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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NumFormat problems when exchanging dot to comma 3
Excel: leader dots and multiple font formats 0
Random Number 2
How to print numbers with dots, regardless of locale 6
Thousand/Decimal seperator 3
Excel Conditional Formatting 1
Why does Excel think this is a number? 6
How to print numbers invariably using dots as decimal symbol? 9

Back
Top