Thousand separator not working right

Agga · Feb 21st, 2002, 03:42 PM

Does anyone know how to make the thousand separator work properly? When I got to format number and tick the thousand separator box my number does not look like this: 1.000.000 but like this: 1000000.0.00

Where can I change it to the default setting?
Please help.
Thanks

Derek · Feb 21st, 2002, 05:37 PM

Hi Agga
Try going to Control Panel, Regional Settings and select the Numbers tab. There are quite a few conditions here that you can change.
If this is all correct, and its only one sheet causing a problem, try pasting the formatting from a sheet that does display correctly.
Hope this helps
Derek

Agga · Feb 22nd, 2002, 10:57 AM

Thanks for your reply Derek.
I've done that, and it works i.e. to paste from another document with right settings. But the default settings are always the same. So whenever I open a new document or transfer into a .csv file the numbers are not displayed in the right manner and I have to do so much work to fix the number allover.

Anybody has a solution?????

Thank

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 03:42 PM	#1
Agga New Member Join Date: Feb 2002 Location: Iceland Posts: 6	Does anyone know how to make the thousand separator work properly? When I got to format number and tick the thousand separator box my number does not look like this: 1.000.000 but like this: 1000000.0.00 Where can I change it to the default setting? Please help. Thanks

Feb 21st, 2002, 05:37 PM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi Agga Try going to Control Panel, Regional Settings and select the Numbers tab. There are quite a few conditions here that you can change. If this is all correct, and its only one sheet causing a problem, try pasting the formatting from a sheet that does display correctly. Hope this helps Derek

Feb 22nd, 2002, 10:57 AM	#3
Agga New Member Join Date: Feb 2002 Location: Iceland Posts: 6	Thanks for your reply Derek. I've done that, and it works i.e. to paste from another document with right settings. But the default settings are always the same. So whenever I open a new document or transfer into a .csv file the numbers are not displayed in the right manner and I have to do so much work to fix the number allover. Anybody has a solution????? Thank