formatting Cells for # sign

G

gevew

I am working in a spreadsheet that contains Purchase Order Numbers and would
like to enter the PO # as just the number (ie: 142) and have the # sign
appear before the number (like with happens when you format for $. Is there
a way to do this. I have tried to create my own style but can't get it to
work.
 
D

Dave Peterson

You could use a custom format of:

\#General

Select the range
format|cells|Number tab|custom category.

Or
\#0000000000
if you have to have 10 digits with leading 0's (say)
 
M

max power

go to format cells then under the number tab select custom and type this into
the text line

"#"###;-"#"###


regards max
 
Top