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

"Emece" wrote in message
...
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.-

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" wrote:

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

0"."000"."000-0

--


Regards,


Peo Sjoblom

"Emece" wrote in message
...
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.-

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

"Emece" wrote in message
...
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" wrote:

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

0"."000"."000-0

--


Regards,


Peo Sjoblom

"Emece" wrote in message
...
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.-