Format cells

Agga · Feb 23rd, 2002, 05:01 AM

Hi everybody!
When I have a number in a cell (like 1200000)and want to format it to look like 1.200.000. I go to format - number and click on the thousand seperator. What happens is that the number looks like 1200000.0.00 and the negative numbers look like -1.10/.10
Does anyone know how to change the number format so it looks normal? I've looke in the control panel- regional settings and the settings are all right there but still the numbers in excel look all wrong when I use the thousands separator.
Can anyone help.... I've been trying to fix this for days....with out luck.
Thanks a buch....

aryan_hr · Feb 23rd, 2002, 07:54 AM

Hi,
go to format - number and decrease "Decimal places" to zero.
now: 1200000====> 1,200,000

Good Luck!

Agga · Feb 24th, 2002, 08:18 AM

Thanks Aryan_hr..... but that's not the solution. It doesn't matter if I change the decimal settings. The number then goes from being 100000.0.00 to 100000.
So it doesn't seperate by thousands at all the decimal just goes to the back.
Sigh..... seems like this is unsolvable.
I've also tried to throw excel out and set it up again.... but it does not change back.
Anybody???????

Aladin Akyurek · Feb 24th, 2002, 08:42 AM

Quote:

On 2002-02-24 07:18, Agga wrote:
Thanks Aryan_hr..... but that's not the solution. It doesn't matter if I change the decimal settings. The number then goes from being 100000.0.00 to 100000.
So it doesn't seperate by thousands at all the decimal just goes to the back.
Sigh..... seems like this is unsolvable.
I've also tried to throw excel out and set it up again.... but it does not change back.
Anybody???????

Did you ever open that workbook on a different machine with an Excel copy of its own in order to see how the formatting then looks like?

Agga · Feb 25th, 2002, 04:10 AM

Thanks Aladin for your answer...
I have not tried to open it on my computer at work. I'm afraid that the settings in my homecomputer might scramble the settings in my excel at work. I think that an excel-document from another computer, sent to me via e-mail, scrambled the thousand seperator settings at some point. But I haven't found a way to restore it to the original setting. Do you know of a way?

Aladin Akyurek · Feb 25th, 2002, 06:58 AM

Have a look at free ASAP Utilities, downloadable from

http://www.asap-utilities.com/

Agga · Feb 25th, 2002, 08:23 AM

Thanks a lot for all your help Aladin.

I'm sure that these add-ins will come in extremely handy. So if I can't repair the thousand separator.... who cares

I've got loads of new tools.

Thanks again for your help... much appreciated.

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

Feb 23rd, 2002, 05:01 AM	#1
Agga New Member Join Date: Feb 2002 Location: Iceland Posts: 6	Hi everybody! When I have a number in a cell (like 1200000)and want to format it to look like 1.200.000. I go to format - number and click on the thousand seperator. What happens is that the number looks like 1200000.0.00 and the negative numbers look like -1.10/.10 Does anyone know how to change the number format so it looks normal? I've looke in the control panel- regional settings and the settings are all right there but still the numbers in excel look all wrong when I use the thousands separator. Can anyone help.... I've been trying to fix this for days....with out luck. Thanks a buch....

Feb 23rd, 2002, 07:54 AM	#2
aryan_hr Board Regular Join Date: Feb 2002 Location: Calgary Canada Posts: 222	Hi, go to format - number and decrease "Decimal places" to zero. now: 1200000====> 1,200,000 Good Luck!

Feb 24th, 2002, 08:18 AM	#3
Agga New Member Join Date: Feb 2002 Location: Iceland Posts: 6	Thanks Aryan_hr..... but that's not the solution. It doesn't matter if I change the decimal settings. The number then goes from being 100000.0.00 to 100000. So it doesn't seperate by thousands at all the decimal just goes to the back. Sigh..... seems like this is unsolvable. I've also tried to throw excel out and set it up again.... but it does not change back. Anybody???????

Feb 25th, 2002, 04:10 AM	#5
Agga New Member Join Date: Feb 2002 Location: Iceland Posts: 6	Thanks Aladin for your answer... I have not tried to open it on my computer at work. I'm afraid that the settings in my homecomputer might scramble the settings in my excel at work. I think that an excel-document from another computer, sent to me via e-mail, scrambled the thousand seperator settings at some point. But I haven't found a way to restore it to the original setting. Do you know of a way?

Feb 25th, 2002, 06:58 AM	#6
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	Have a look at free ASAP Utilities, downloadable from http://www.asap-utilities.com/

Feb 25th, 2002, 08:23 AM	#7
Agga New Member Join Date: Feb 2002 Location: Iceland Posts: 6	Thanks a lot for all your help Aladin. I'm sure that these add-ins will come in extremely handy. So if I can't repair the thousand separator.... who cares I've got loads of new tools. Thanks again for your help... much appreciated.