Why does this date conversion number work?

T

Tornados

Hello i had a little problem.... Excel sees a certain date as a date
however has the wrong month/day order:

06/09/2004 sees excel as a date: 6 september, however i mean it to be
june....

Function Datum_mmddyy(datum As Date) As Date

Datum_mmddyy = Format(datum, "dd/mm/yyyy")

End Function


I now have this function and it actually works in converting th
date... i don't quite understand why though haha as it is formatting..
 
F

Frank Kabel

Hi
some ideas:
- check your regional settings for the default date format
- preformat the cell with the correct format for your date
before entering a value
 

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

Excel 2002: How to make the date format uniform ? 1
Convert dates stored as text 2
Excel 2007 displayed dates 2
date query 2
Convert military date system to standard date system 8
Date and years calculation 2
Date Formats 1
Formatting Text to Numbers for Dates 2

Top