Previous Topic Next Topic

Convert date format

Closed
romer - Nov 17, 2009 at 08:06 AM
 fsf - Jun 2, 2010 at 11:58 PM
Hello:

I would like to know how to convert this date format 20091015 (for 2009-10-15) to 10/15/2009. A solution might be to insert a dash between the year-month and between the month-day, however I don't know how to do that. If that were possible, I would be able to format the cells to dd/mm/yyyy.

2 responses

Answer 1 / 2
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Nov 17, 2009 at 03:46 PM
have a read of this link
http://www.ozgrid.com/forum/showthread.php?t=75930

i think it explains a solution to your problem.
0
Answer 2 / 2
fsf
Jun 2, 2010 at 11:58 PM
ss
0

Similar discussions

How to convert date into words
shahid -
2massive-head -

2 responses
Date of birth in words
pinckroje -
TrowaD -

1 response
Unsupported signal. Please check device output
S.Agnew -
Yaya68 -

14 responses