Need help with date function

  • Thread starter Thread starter Lynda Hardin
  • Start date Start date
L

Lynda Hardin

I have a column that is date only and all was well until
yesterday. Now all I have are numeric numbers but they
are not dates. BUT in the address line it shows the
correct date. Any help is appreciated.
 
Hi Lynda

without seing a sample of the numbers displayed i'm guessing they're the
serial number that excel uses to store the date - this means that the cells
have probably been formatted as "general" or "number" or similar instead of
a date format.

select the cells, choose format / cells from the menu, go to the number tab
and choose a date format for these

hope this helps

Cheers
JulieD
 
Hi

Maybe your cells are not formatted as dates? Excel stores dates as numbers
since 01/01/1900, and that is maybe why you can see numbers. Format the
cells as dates.
 
Back
Top