Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date dd/mm/yy in the cell, but mm/dd/yy in formula bar
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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date dd/mm/yy in the cell, but mm/dd/yy in formula bar
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. sfp wrote: 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!! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need the formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date | Excel Discussion (Misc queries) | |||
Help w/formula to add 1 year to cell (date done) date due? | Excel Worksheet Functions | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
Need to use IF formula with a Date cell | Excel Worksheet Functions |