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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to format cell to display S("6 digit number here)
On Tue, 30 Dec 2008 03:17:02 -0800, prem
wrote: 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 This custom format seems to work: \S(000000) Note that the minimum number of digits that will be displayed is six (left-padded with leading zero's). --ron |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to format cell to display S("6 digit number here)
"Ron Rosenfeld" wrote: On Tue, 30 Dec 2008 03:17:02 -0800, prem wrote: 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 This custom format seems to work: \S(000000) Note that the minimum number of digits that will be displayed is six (left-padded with leading zero's). --ron Thank you Ron That worked as I wanted to. Appreciate the help. Regards, Prem |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to format cell to display S("6 digit number here)
On Tue, 30 Dec 2008 03:50:01 -0800, prem
wrote: Thank you Ron That worked as I wanted to. Appreciate the help. Regards, Prem You're welcome. Thanks for the feedback. --ron |
Reply |
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) |