zero
 

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

zero
 

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

zero
 

Hi Niek Otten
thank you very much works great

"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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