If you type that number in, then type it as '09123456789, i.e. with a
leading apostrophe. The apostrophe will not show in the cell.

If you have a lot of these values, say in column A, then you could use
column B with a formula like this:

=TEXT(A1,"00000000000")

if your values are all 11 digits long, and copy this down. You could
then fix the values in column B, and delete column A.

Hope this helps.

Pete

On Dec 7, 2:16*pm, Rumy wrote:
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 !!!