inserting '0' into a excel cell
 

hi i trying to put a phone number into a cell in a excel workbook, the
number starts with 0191 ( the diling code) , the computer sees this as
a minus and drops the '0' for a '-'.
how can i include the '0' in the phone number?
thanks
john


--
johnny.exe
------------------------------------------------------------------------
johnny.exe's Profile: http://www.excelforum.com/member.php...o&userid=30775
View this thread: http://www.excelforum.com/showthread...hreadid=517735

inserting '0' into a excel cell
 

Putting an apostrophe first is one way: '01234


--
cycling-rod
------------------------------------------------------------------------
cycling-rod's Profile: http://www.excelforum.com/member.php...o&userid=13520
View this thread: http://www.excelforum.com/showthread...hreadid=517735

inserting '0' into a excel cell
 

Cycling-rod's suggestion correctly enters the number as text (which is not
truncated) rather than a number (which is truncated). If you wish to avoid
having to enter the apostrophe before each phone number, then format the
data entry range as text (select format-cells-number-text) and the zeros
will automatically be stored.


"cycling-rod"
wrote in message
...

Putting an apostrophe first is one way: '01234


--
cycling-rod
------------------------------------------------------------------------
cycling-rod's Profile:
http://www.excelforum.com/member.php...o&userid=13520
View this thread: http://www.excelforum.com/showthread...hreadid=517735