DATES IN EXCEL 2004 FOR MACPRO

M

maggypeeters

INPUT OF DATES IS IMPOSSIBLE IN THE EUROPEAN WAY BEING DD-MM-YY
INPUT HAS TO BE MADE IN THE USA WAY BEING MM-DD-YY
DATES SHOWN IN THE FORMULA BAR SHOW AS AS MM-DD-YY
WHEN INPUT IS DONE IN A COLUMN THAT WAS FORMATTED TO SHOW DD-MM-YY IT
HAS STILL TO BE DONE AS MM-DD-YY

HOW CAN THIS BE SOLVED?
 

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

VBA - exporting serial letters to single documents 0
How to enter a date in DD-MM-YYYY format 2
Date Format 10
Edit Date 1
International Date Formats in Excel 4
International Date Cell Format 1
yet another date format problem 3
date format not working 1

Top