Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|