Date Problem

D

Don Guillett

If that is referring to the 31st of November, unless there is a new leap
year for November, Excel would be confused.

--
Don Guillett
SalesAid Software
(e-mail address removed)
Gary Pickett said:
When I type 31/11/03 in a cell it will not follow the same format as the
Click to expand...
rest of the dates I have typed in. Can anyone please tell me why? I am using
Excel from Office 2000 on XP Home Operating System.
 
G

Gary Pickett

When I type 31/11/03 in a cell it will not follow the same format as the rest of the dates I have typed in. Can anyone please tell me why? I am using Excel from Office 2000 on XP Home Operating System.
 

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

how to use time format to present negative value? ex. -00:42 min 3
Another COUNTIF question 2
Date Entry Problem 4
big file 2 3
Date Question 7
Calc Prorated Cost based on Specific Days in a Given Month & Year Range (Revisited..) 8
Date lists 3
Calc Prorated Cost based on Specific Days in a Given Month & Year Range 3

Top