Format a number to be displayed divided by 1000

[terragnog]

Hi all,
this is my first post. I looked for the solution but I didn't find the solution.

This is the question:

I have a worksheet and when I write a number, i.e. 1000 I want that this number will be displayed as 1 (1000 divided by 1000).

The number must remain 1000 but displayed as 1.

The number 1245 should be displayed as 1,245

Thanks
Gianluca

 

[Richard Schollar]

Hi

Set a custom format on the cell(s) via Format>Cells>Number tab and hit the Custom catergory and use:

#,##0,;-#,##0,

Note the comma after the zeros.

EDIT: I'm not certain what format you exactly want. It looks like you may want 3 decimal places? In which case use:

#,##0.000,;-#,##0.000,

 

[terragnog]

Thanks a lot.

I realized that the format depends on the localization of the system.

I am working in Switzerland and I wrote #'##0' and It works fine.

I don't understand why You wrote also the part -#,##0,

Thanks againg,
Gianluca