date formating problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This problem has started.

When I key in a number into cell and format as date, it now treats the
number like it were a Julian date. I have opened old spreadsheet that are
formatted as dates, then have keyed into an open cell, a number and format as
a date, and it displays it as a Julian date.
 
If you put 3/24/2007 ( or 24/3/2007 ) into a cell and it displays:

39165

then the problem is probably just a display option. For example CNTRL-~
will do this. There might be others.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Different date formats 1
Dates in different formats 2
Three Digit Julian Date 4
how to convert from julian date to mm/dd/year 6
convert Julian Date Format to Excel 1
How to Convert a Julian Date to Calendar Date 2
Number of the day of the year 3
Formula to show when the julian date changes 1

Back
Top