Formatting to show 0 as first number in a cell when input triffidbook 22.09.2006 07:22:02 How do I format a cell so it automatically shows a 0 as the first digit when I input a numeric value insted of using the ' prefix? The cell is used for order numbers which can begin with a 0

Re: Formatting to show 0 as first number in a cell when input Max 22.09.2006 07:29:02 One way .. Assuming its a 5 digit series (00000) Select the col, Click Format > Cells > Number tab Choose Custom, type: 00000 Click OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "triffidbook" wrote: [Quoted Text] > How do I format a cell so it automatically shows a 0 as the first digit when > I input a numeric value insted of using the ' prefix? The cell is used for > order numbers which can begin with a 0

Re: Formatting to show 0 as first number in a cell when input Max 22.09.2006 08:23:01 In the line: [Quoted Text] > Choose Custom, type: 00000 Just adjust the number of zeros to suit, of course (you could try using just: 00 for example) -- Max Singapore http://savefile.com/projects/236895 xdemechanik ---

Re: Formatting to show 0 as first number in a cell when input "David Biddulph" <david[ at ]biddulph.org.uk> 22.09.2006 11:32:45 "triffidbook" <triffidbook[ at ]discussions.microsoft.com> wrote in message news:9B1D4C72-0922-49BD-A065-0FB4F3F74145[ at ]microsoft.com... [Quoted Text] > How do I format a cell so it automatically shows a 0 as the first digit > when > I input a numeric value insted of using the ' prefix? The cell is used > for > order numbers which can begin with a 0 Format the cell as text prior to entering the data. -- David Biddulph

Re: Formatting to show 0 as first number in a cell when input triffidbook 22.09.2006 12:01:02 Thanks guys. :) "David Biddulph" wrote: [Quoted Text] > "triffidbook" <triffidbook[ at ]discussions.microsoft.com> wrote in message > news:9B1D4C72-0922-49BD-A065-0FB4F3F74145[ at ]microsoft.com... > > How do I format a cell so it automatically shows a 0 as the first digit > > when > > I input a numeric value insted of using the ' prefix? The cell is used > > for > > order numbers which can begin with a 0 > > Format the cell as text prior to entering the data. > -- > David Biddulph > > >

Re: Formatting to show 0 as first number in a cell when input "Max" <demechanik[ at ]yahoo.com> 25.09.2006 01:56:56 You're welcome. Do note the subtle difference: David's method changes the source numbers to text while my suggestion preserves it as numbers. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "triffidbook" <triffidbook[ at ]discussions.microsoft.com> wrote in message news:2E136565-5268-42CC-9A2A-8BEADA163136[ at ]microsoft.com... [Quoted Text] > Thanks guys. :)