Date format available in Excel

G

Guest

I dont see dd/mm/yy or dd/mm/yyyy format in Excel for Date.

I know I can create custom format but than whenever I open file on some
other machine it appears in mm/dd/yy format, I have to create custom format
on machine where I open document. So what is solution for this.
 
D

David Biddulph

Have you looked at changing the Locale (location) below the date formats on
the Format Cells/ Number tab?
 

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

Preserving date format 1
date format 1
Excel 2002: How to make the date format uniform ? 1
WHY DOES DATE FORMAT CHANGE IN COLUMN 1
Conditional formatting of date-cell - 2007 5
Date format - India/USA 7
Count Between dates 11
Date Format 9

Top