Keeping date format of a field inserted from an excel database

G

Guest

The format of the date keeps showing in the field as mm/dd/yy (ie US format)
instead of UK dd/mm/yy. Database has it set correct, I've checked regional
settings within word & excel and also regional settings of the system from
the control panel.
I've tried adding field switching codes but that throws up an error and
wants to remove the field altogether as its not in the database... Please
help
 
A

Alan

Are you importing these dates? If you format one as general, does it show a
number?
Regards,
Alan.
 

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

Change date format in Excel footer 2
date format 1
How do I calculate age using a 12 digit social security number in MS Excel? 0
Forcing a date entry format of dd/mm/yyyy 1
Header/Footer Date Format 2
Excel is changing date format incorrectly 7
Date format problems after csv import 2
Vijay 3 1

Top