Format number 0.000,000 to 0'000 ?

[Dimitris254]

For example number 67,194 (194 are decimals).
I'd like it to appear as 67.
A bigger number e.g. 12345,194 would appear 12'345.

I tried NumberFormat = "0'000" and = "#'##0", but they don't work.

The first gives 0'067, the second give '67.

 

[Michael M]

Format as Number with zero decimal places !

 

[Dimitris254]

but i need the tone for thousands too...

 

[MarcelBeug]

Format as: [>=1000]#'##0;0

Note: this won't work for any negative numbers <= -1000. That would require conditional formatting.

 

[Dimitris254]

thanks MarcelBeug, looks to work perfectly

regarding your note, isn't [>=1000] already a condition?

 

[pgc01]

Hi

For both >1000 and <-1000 you could add a second condition, like:

[>=1000]#'##0;[<=-1000]-#'##0;0

 

[Dimitris254]

crystal clear, cheers guys