Previous Topic Next Topic

Dates not formatting correctly

Closed
MB - May 5, 2010 at 07:11 PM
 Blocked Profile - May 6, 2010 at 12:51 AM
Hi, I'm trying to format Dates as dd/mm/yyyy in excel, but my dates after 31/12/1999 are not been formatted correct. i.e 01/01/2010 is not being recognised as a date

1 response

Answer 1 / 1
Blocked Profile
May 6, 2010 at 12:51 AM
Dear MB,

Once you close the file and open it again, it might be that the date format is getting to the default one and hence you will have to set this specific format to the default one for having it recognized as a date.

Thanks in advance.
0

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

1 response
IF statements with dates and criteria
jimbabama -
Mazzaropi -

3 responses
blank white page for website
yadaves -
ac3mark -

1 response
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
using web browser page loads but screen blank
inchoate -
leo -

16 responses