View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gevew gevew is offline
external usenet poster
 
Posts: 8
Default formatting Cells for # sign

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.