Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting Cells for # sign
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) 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. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting Cells for # sign
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
How to copy "edge" formatting to other cells. | Excel Discussion (Misc queries) |