Previous Topic Next Topic

Date formatting

Closed
bhavana28 Posts 1 Registration date Monday September 16, 2013 Status Member Last seen September 16, 2013 - Sep 16, 2013 at 08:37 AM
 Blocked Profile - Sep 16, 2013 at 08:46 AM
I WONT DATE FORMAT (dd/mm/yy) BUT IN MY EXCEL IT SHOWS (mm/dd/yyyy) IN FORMULA BAR. PLEASE HELP ME. I HAVE SO MANY WORK WITH THIS DATE.

1 response

Answer 1 / 1
Blocked Profile
Sep 16, 2013 at 08:46 AM
Good Morning,

This should help : =text(value,"ddmmyy")

Good Luck, Have fun!

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
How do i change date format in (dd.mm.yyyy)
Talha -
Catherine -

6 responses
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response