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" wrote in message
...
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 !!!