Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to format cell to display S("6 digit number here)
Hi guys I need to know how I can format cell such that when I enter a 6 digit
number such as "035891", it will be displayed as "S(035891)" instead. So basically I want the number I input to be displayed in brackets with a uppercase "S" placed in front, outside the brackets. Also, any zeros typed in, be it at the start or end, must be displayed. Thank you guys for your help. Regards, Prem |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to format cell in excel for 12 digit number starting with a 0 | Excel Discussion (Misc queries) | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
Format cell to display "Y" or "N"when entering a 1 or zero | Excel Discussion (Misc queries) | |||
16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) |