B
BdgBill
This is driving me nuts!
I use excel 2000.
From time to time certain cells (usually blocks of cells or an entir
row) containing numerical data lose all formatting. Excel no longe
recognizes the data as numbers and will not sort them etc. Selectin
the cell(s) and changing the formatting has no effect. Copying, the
"paste special / values" only works sometimes. Manually retyping th
data over the old usually works but I am dealing with a spreadshee
with about 1000 records.
I just had this happen with a row containing date / time stamps.
Each cell has an entry like "7/26/04 9:53". I can usually change th
formatting of this info to display just the date just the time etc. No
I can do nothing with them. It's like Excel thinks the cells contai
plain text.
I did notice that selecting a single cell, then placing the cursor i
the formula bar, then pressing enter will bring that one cell back t
life, but this is not practical for 1000 records.
Any ideas
I use excel 2000.
From time to time certain cells (usually blocks of cells or an entir
row) containing numerical data lose all formatting. Excel no longe
recognizes the data as numbers and will not sort them etc. Selectin
the cell(s) and changing the formatting has no effect. Copying, the
"paste special / values" only works sometimes. Manually retyping th
data over the old usually works but I am dealing with a spreadshee
with about 1000 records.
I just had this happen with a row containing date / time stamps.
Each cell has an entry like "7/26/04 9:53". I can usually change th
formatting of this info to display just the date just the time etc. No
I can do nothing with them. It's like Excel thinks the cells contai
plain text.
I did notice that selecting a single cell, then placing the cursor i
the formula bar, then pressing enter will bring that one cell back t
life, but this is not practical for 1000 records.
Any ideas