J
John Dann
An Excel (2000) spreadsheet that I use regularly has had its column
formats (though fortunately not the data) corrupted following a PC
crash. There's a couple of columns that I use for storing
latitude and longitude data in the format eg 52:00:00.
Since the corruption, Excel insists on treating this column format as
Time (and adding a Date prefix if I try to edit one of the affected
cells). I know I encountered this same problem previously and managed
to fix it but can't remember the fix. If I select the colum and do
Format Cells | Text then all the values immediately change to decimal
numbers such as 2.123456789 !!
Anyone have any thoughts please as to what might be amiss and how to
correct it?
JGD
formats (though fortunately not the data) corrupted following a PC
crash. There's a couple of columns that I use for storing
latitude and longitude data in the format eg 52:00:00.
Since the corruption, Excel insists on treating this column format as
Time (and adding a Date prefix if I try to edit one of the affected
cells). I know I encountered this same problem previously and managed
to fix it but can't remember the fix. If I select the colum and do
Format Cells | Text then all the values immediately change to decimal
numbers such as 2.123456789 !!
Anyone have any thoughts please as to what might be amiss and how to
correct it?
JGD