inserting '0' into a excel cell

[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]

Putting an apostrophe first is one way: '0123

 

[John James]

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]...