T
Trevor McArthur
I posted a similar problem in Office/Miscellaneous.
I made a spreadsheet to keep contact info. One collumn was telephone
numbers formatted special/telephone nmbers. the odd thing is,
sometimes when I put a 10-digit phone number in, it automaticcally
switches to a 5- digit number, like an inter-office extention (ie 5-
5555). Usually the same number, but sometimes I try to replace the
short number and al it does is change which short number displays, as
if a formula was being applied and this is the answer.
I have seen this happen before, but recently when I opened the file on
Excel 97 SR-1 through Win 98 on virtual PC on a Mac, almost all the
long phone numbers were shortened, and changing the cell formatting
resulted in the same change unless formatted as TEXT. Any ideas?
I made a spreadsheet to keep contact info. One collumn was telephone
numbers formatted special/telephone nmbers. the odd thing is,
sometimes when I put a 10-digit phone number in, it automaticcally
switches to a 5- digit number, like an inter-office extention (ie 5-
5555). Usually the same number, but sometimes I try to replace the
short number and al it does is change which short number displays, as
if a formula was being applied and this is the answer.
I have seen this happen before, but recently when I opened the file on
Excel 97 SR-1 through Win 98 on virtual PC on a Mac, almost all the
long phone numbers were shortened, and changing the cell formatting
resulted in the same change unless formatted as TEXT. Any ideas?