how to format cell to display S("6 digit number here)

  • Thread starter Thread starter prem
  • Start date Start date
P

prem

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
 
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
Click to expand...

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
 
Ron Rosenfeld said:
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
Click to expand...
Thank you Ron That worked as I wanted to. Appreciate the help.

Regards,
Prem
 
Back
Top