Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |