Tom's Guide | Tom's Hardware | Tom's Games
 |
 |
 |
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"
0 
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
0
[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
0
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 ofDD/MM/YY
Click OK and your done.
Use it like any other Date Format.
MIKE
0
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)
0
re: it will be at the very bottom of the list...
...until another custom format is added.
(Just clarifying) :-)
0
<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
0
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?
0
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.
0  |
 |
 |
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |
