I have tried to change a number from 12,345678 to 12.345678 and the result was that Excel converted the number to 12.345.678. Help me please and tell me how to simply change the comma with a dot without groupping automatically the number to thousands. Thank you!
Excel 2007 number formatting(6 posts)
It looks like your system default decimal is a comma (,) and thousand separator is a period (.)
You'll need to go to Control Panel/Region and Language/ Additional Settings in the Format tab and change the Decimal symbol to a period (.) and the digit Grouping to a comma (,). Then in Excel set the format as General
I tried and now I have this situation: on my PC it's ok, every number is with dots, but I sent the Excel sheet to other country and there when opened every dot is turned to comma. I must say that I use Excel 2007 and on the other computer is Excel 2010. I do not know what to do anymore. A little help will be appreciated.
This topic has been closed to new replies.