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?
 
Top