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

[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

 

[Ron Rosenfeld]

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

 

[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

 

[Ron Rosenfeld]

Thank you Ron That worked as I wanted to. Appreciate the help.

Regards,
Prem

You're welcome. Thanks for the feedback.
--ron