how to format cell to display S("6 digit number here) prem 12/30/2008 11:17:02 AM 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

Re: how to format cell to display S("6 digit number here) Ron Rosenfeld <ronrosenfeld[ at ]nospam.org> 12/30/2008 11:32:39 AM On Tue, 30 Dec 2008 03:17:02 -0800, prem <prem[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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

Re: how to format cell to display S("6 digit number here) prem 12/30/2008 11:50:01 AM "Ron Rosenfeld" wrote: [Quoted Text] > On Tue, 30 Dec 2008 03:17:02 -0800, prem <prem[ at ]discussions.microsoft.com> > 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

Re: how to format cell to display S("6 digit number here) Ron Rosenfeld <ronrosenfeld[ at ]nospam.org> 12/30/2008 1:12:57 PM On Tue, 30 Dec 2008 03:50:01 -0800, prem <prem[ at ]discussions.microsoft.com> wrote: [Quoted Text] >Thank you Ron That worked as I wanted to. Appreciate the help. > >Regards, >Prem You're welcome. Thanks for the feedback. --ron