inserting '0' into a excel cell

  • Thread starter Thread starter johnny.exe
  • Start date Start date
J

johnny.exe

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
 
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" <[email protected]>
wrote in message
news:[email protected]...
 
Back
Top