Format Cells - Custom

[Emece]

I need to assign a custom format to a cell, in order to display numbers in
this format: 1.234.567-8
How should I specify the format?

Thanks in advance

Best Regards,
Emece.-

 

[Peo Sjoblom]

I assume you always have an 8 digit number with no decimals, use custom
format

0"."000"."000-0

--


Regards,


Peo Sjoblom

 

[Emece]

Great, this works. Thanks for your prompt reply.

One more question, can you please explain me the use of the " in the format?

Thanks once again

 

[Peo Sjoblom]

Otherwise the dots which are decimal delimiters using US number format
will screw up the format. If we used

0.000.000-0


it would look like this


12345678.000.000-0

By putting quotations around the periods they will
be seen as text and not delimiters.

For instance if you want to display a number with a pound sign like this

#12545678

you cannot use

#00000000

if you use

"#"00000000 it will work

That is because the pound sign is used for formatting numbers like

12,345,678.00

using #,##0.00


HTH



--


Regards,


Peo Sjoblom