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

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


regards max

"gevew" wrote:

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.