LinkBack URL
About LinkBacks
How would I go about converting this number to a date?
1120927
the date should be 09/27/2012.
Thanks!
How would I go about converting this number to a date?
1120927
the date should be 09/27/2012.
Thanks!
=TEXT(A1,"dd-mm-yyyy")
Type a value in A1
Fredy
first thing i tried but not so. the numbers are in a weird order. im guessing are some kind of uniquqe refernce.Originally Posted by Fredy.Antony
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
@
twiggywales
Yes number are weird .. if that date is in a number format this formula will work
@ Pete_UK
=VALUE(MID(A1,4,2)&"/"&RIGHT(A1,2)&"/20"&MID(A1,2,2))
This formula works
Last edited by Fredy.Antony; 10-03-2012 at 10:01 AM. Reason: Corrected
Worked like a charm, thanks
dunno its a bit wierd but i guess this
A1 is where your date munber is
MID(A1,4,2)&"/"&RIGHT(A1,2)&"/20"&MID(A1,2,2)
Just to add to Twiggy's solution, if you want a proper date returned then you can do this:
Formula:
=VALUE(MID(A1,4,2)&"/"&RIGHT(A1,2)&"/20"&MID(A1,2,2))
Format the cell as a date.
Hope this helps.
Pete
remeber to mark it solved and star tap the posts that helped
Sorry, how do I mark as solved?
Another way:
=--TEXT(20 & MOD(A1, 1000000), "0000-00-00")
Entia non sunt multiplicanda sine necessitate
Everything you need to know: Forum Rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks