Look at 'Create a custom number format' in help.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Kathrine" wrote in message
...
When formatting numbers in Excel (format cells - numbers) the bottom
choice
is to make your own type of format. Can anyone please let me know how the
symbols actually work: # 0 _ and so on. Thanks! URGENT!