Hello,
Just a general question related to dates in Excel. Ironic I'm asking this on Valentine's Day.
I have a spreadsheet generated from the SAS software, where the dates are in 11DEC2016:00:00:00 format.
I would want to what this date type is called, and how I could easily convert it in excel. So far, I only know Ctrl+H and replace the timestamp.
Thanks and have a nice day ahead!
Regards
Asar
You could use formula:
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Or using Power Query, you could use a transformation like:
Please Login or Register to view this content.
Here is another way
Formula:Please Login or Register to view this content.
Format as Date
v A B 1 11DEC2016:00:00:00 12/11/2016
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks