Thank U sir. Great to find someone in S'pore answering my question.:) ok i
have over 5000 rows. So i cant manually type the zero. Is there a easy way to
put that zero in all the cells ,plz ? I change to text already. Thkz

"Max" wrote:

What you see within the formula bar of the cell is always the real, true
value. If you want the leading zero to be included as part of the real value,
you must either format that cell as TEXT first, then key-in the leading zero
(or precede the leading zero input with an apostrophe). Any worth? hit the
YES below
--
Max
Singapore
xde
---
"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 !!!