F
FuzzDude
Two issues I'm stumped on.
1. I've received reports with the dates listed in a
totally numeric form (20040811). I've managed to convert
it to 11/08/2004, pasted the new value only, formatted the
cells for the 11/Aug/04 format, but can only get that to
display after cliking and editing each cell. There must be
a better way to refresh the view mustn't there?
2. I highlighted and modified an entire column rather than
just those containing data. Now I have in excess of 66,000
records. Even deleting the excess, my scroll bar is huge,
as it still recognizes the 'dead' cells. Is there a quick
fix if I do this again?
Thx
Fuzz
1. I've received reports with the dates listed in a
totally numeric form (20040811). I've managed to convert
it to 11/08/2004, pasted the new value only, formatted the
cells for the 11/Aug/04 format, but can only get that to
display after cliking and editing each cell. There must be
a better way to refresh the view mustn't there?
2. I highlighted and modified an entire column rather than
just those containing data. Now I have in excess of 66,000
records. Even deleting the excess, my scroll bar is huge,
as it still recognizes the 'dead' cells. Is there a quick
fix if I do this again?
Thx
Fuzz