LinkBack URL
About LinkBacks
I have a spreadsheet that for some reason has dates entered like this:
Col A Col B Col C
10 3 2010....................for October 3, 2010
How can I convert this into a proper date?
I have a spreadsheet that for some reason has dates entered like this:
Col A Col B Col C
10 3 2010....................for October 3, 2010
How can I convert this into a proper date?
=date(c2,a2,b2)
=TEXT(DATE(C1,A1,B1),"mmmm d,yyy")
Perfect. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks