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