Format Cells - Custom

  • Thread starter Thread starter Emece
  • Start date Start date
E

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.-
 
I assume you always have an 8 digit number with no decimals, use custom
format

0"."000"."000-0

--


Regards,


Peo Sjoblom
 
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
 
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
 
Back
Top