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
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
Putting an apostrophe first is one way: '01234
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]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks