Previous Topic Next Topic

Date formatting issue

Closed
ogeneblorien Posts 4 Registration date Wednesday July 30, 2014 Status Member Last seen July 31, 2014 - Jul 30, 2014 at 05:55 PM
 Blocked Profile - Jul 31, 2014 at 05:23 PM
Hi all.. I copied dates from a Web page in this format 'Fri Jul 25 2014' but I need these dates changed to '25/07/2014'. I have tried most of the date formatting techniques I saw on here but none works for me.
Help please.
Related:

3 responses

Answer 1 / 3
Blocked Profile
Jul 31, 2014 at 09:29 AM
And this affects an android device how?

You have posted this in an android thread. Is this a spreadsheet problem?
Answer 2 / 3
ogeneblorien Posts 4 Registration date Wednesday July 30, 2014 Status Member Last seen July 31, 2014
Jul 31, 2014 at 03:24 PM
@ac3mark yes it is a spreadsheet problem. I have the problem on my laptop spreadsheet.
Answer 3 / 3
Blocked Profile
Jul 31, 2014 at 05:23 PM
OK, try this:
=TEXT(THECELLTOCHECK,"dd/mm/yyyy")

I hope this helps!

Similar discussions

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

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

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

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

1 response