Excel date format in dd/mm/yy

March 27, 2009 at 16:13:28
Specs: Windows XP, Any

http://www.computing.net/answers/of...

I have got same issue in the link above, how can I change date format in Excel 2003 to dd/mm/yy (28/03/09),,,,there is no such an option in Format --> Cell --> "Number" tab --> Type,,,,and there is no such an option in "Regional Settings"


See More: Excel date format in dd/mm/yy

Report •


#1
March 27, 2009 at 16:53:31

Format, Cell, Date, Change Locale to English (United Kingdom). You'll see the option you want.

EEOC


Report •

#2
March 27, 2009 at 17:33:03

What you want is Custom Formatting

On 2007 I believe it's

Home tab, Format, Format Cells, Custom

then enter your format

dd/mm/yy

Just realized you wanted 2003, so it's

Format, Cells, Custom


MIKE


Report •

#3
March 27, 2009 at 17:51:39

[quote]Format, Cell, Date, Change Locale to English (United Kingdom). You'll see the option you want.[/quote]
That one works perfect. Thanks for that


[quote]Format, Cells, Custom[/quote]
Are you saying I have to modify pound (hash) sign under custom option ?

For instance this is one of those custom formats :#,##0;[Red],-#,##0.00

Or the picture in this link
http://www.ozgrid.com/Excel/excel-c...

Or Do you mean I have to chose ready made date format under custom option ?,,if you meant this , then there is no such an option that I am after


Report •

Related Solutions

#4
March 27, 2009 at 18:03:57

I mean you can "roll your own".....

When you get to the Custom format window,
in the middle on the right is a small input block under the word Type:
It probably has the word General in it, just highlight the word and delete then in the empty block type in your format of

DD/MM/YY

Click OK and your done.

Use it like any other Date Format.

MIKE


Report •

#5
March 27, 2009 at 18:08:12

re: Use it like any other Date Format...

...except that it will always be found in the Custom list, not the Date list.

(Just clarifying)


Report •

#6
March 27, 2009 at 18:08:17

Yes Mike great , I get it and it worked

Report •

#7
March 27, 2009 at 18:09:53

And just to add to DerbyDad03's comment, it will be at the very bottom of the list.

MIKE


Report •

#8
March 27, 2009 at 18:11:03

Thanks Derby for clarification

Report •

#9
March 27, 2009 at 18:12:19

re: it will be at the very bottom of the list...

...until another custom format is added.

(Just clarifying) :-)


Report •

#10
March 27, 2009 at 18:12:49

<quote>And just to add to DerbyDad03's comment, it will be at the very bottom of the list.</quote>
Yes I have noticed that as well

Report •

#11
May 25, 2009 at 06:00:00

Hello :)

I was wondering if anyone can help me. I've inputted a lot of dates in NZ dates: dd/mmy/yy but I need US setting. Excel won't seem to recognize them as dates but as General only. So I can't just click on mm/dd/yy. Is there another way?


Report •

#12
May 25, 2009 at 06:46:18

I'll assume this is a typo: dd/mmy/yy

I don't think "mmy" is a valid month format.

Try using something like DATEVALUE(text) to see if you can convert the strings to dates.

Try adding adding 1 then subtracting 1 to see if they'll convert: =A1+1-1.

Sometimes when Excel won't let go of a Text or General formatting, it's because there is an extra (hidden) character in the cell. Try =LEN(A1) to see if you get a value equal to the number of characters you actually see.


Report •


Ask Question