J
JGLois
Using Excel 2000. I have pre-formated worksheets in which the date columns
are
formatted to show the date style as 12-Nov-03. All worked fine until
yesterday when
the entries began to show up as pound signs. When I look at the formatting
for the cell,
it appears to be formatted correctly. I have checked with entries entered
before yesterday
and the formatting appears the same.
My knowledge of the program is fairly rudimentary but I thought I could do
the basic
cell formatting by clicking Format, Cells, Number, Catagory - Date, etc.
What am I missing here?
Most grateful for your help.
Lois
are
formatted to show the date style as 12-Nov-03. All worked fine until
yesterday when
the entries began to show up as pound signs. When I look at the formatting
for the cell,
it appears to be formatted correctly. I have checked with entries entered
before yesterday
and the formatting appears the same.
My knowledge of the program is fairly rudimentary but I thought I could do
the basic
cell formatting by clicking Format, Cells, Number, Catagory - Date, etc.
What am I missing here?
Most grateful for your help.
Lois