Yes, but that wasn't what the OP was asking for.
Pete
On Dec 7, 6:59*pm, William <Will...@discussions.microsoft.com> wrote:
> It is also possible to force one or more zeros to display without changing
> the cell format to text, and sometimes this is desirable. *Select the cells,
> go to Format/Cells/CUSTOM and in the "Type" box enter the same number of
> zeros for which you need digits in your cells. * If you enter 000000 and in a
> cell type "1234" it will show as 001234. *
>
> William
>
>
>
> "David Biddulph" wrote:
> > If you want to see the leading zero in the formula bar, you'll need to
> > pre-format the cell as text, or precede your "number" by an apostrophe.*If
> > you do this, the "number" will not be treated as a number, but as text.
> > --
> > David Biddulph
>
> > "Rumy" <R...@discussions.microsoft.com> wrote in message
> >news:A18AEC17-92A8-41E7-8345-(E-Mail Removed)...
> > >I have a cell where the number has a leading zero ( Ex - 09123456789 ).. But
> > > when i select the cell , on the formula bar the leading zero is not
> > > showing (
> > > it shows 9123456789 ) how do i change this format. I want to see the
> > > leading
> > > zero in the formula bar !!!
>
> > .- Hide quoted text -
>
> - Show quoted text -
|
Similar Threads
