Date dd/mm/yy in the cell, but mm/dd/yy in formula bar

S

sfp

I am being supplied a file that displays date as 06/05/09 in the cell, but
05/06/09 in the formula bar. Cell is displaying the value I need, formula
bar is not. Cell is a 'custom' format. When I change to any other format
and try and put it back to date, it becomes 5 June instead of 6 May.

HELP!!
 
D

Dave Peterson

If you give that cell an unambiguous date format like: mmmm dd, yyyy

You'll see the real date/value in that cell.

It sounds to me like the person who supplied the workbook didn't import the
dates correctly -- I'm guessing that the dates came from a text file and they
were imported incorrectly.

They may have looked pretty (as dates), but they didn't represent what the
original data needed.

I'd go back to that person and ask them to import the data again and be very
careful with how those fields are imported.
 

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/create code in MS Word to calculate age? 0
change DD/MM/YY to MM/DD/YY 6
Change from mm/dd/yy to yy/mm> 3
Entering date as MM/DD/YY no longer works, why? 1
dd/mm/yy if i change to some other format 2
Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy 1
Date diffrence in days, weeks and months. 1
How to enter a date in DD-MM-YYYY format 2

Top