zero

[mr bloby]

Hi can any one help with this one
i am trying to enter phone numbers in cells but when the number begins with
a zero it wont recognise it
if i fomat the cell and set it to text it will recognise the zero
is there anyway of doing this without formating and setting to text???
thanks in advance for any help

 

[Niek Otten]

Precede the entry with an apostrophe. It will not show.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi can any one help with this one
| i am trying to enter phone numbers in cells but when the number begins with
| a zero it wont recognise it
| if i fomat the cell and set it to text it will recognise the zero
| is there anyway of doing this without formating and setting to text???
| thanks in advance for any help

 

[mr bloby]

Hi Niek Otten
thank you very much works great