Need help formatting the date and time together in one cell. I copy the date and time from another program and I'm pasting it into a single cell within Excell. This is was the date and time looks like from the other program. 2013-09-03 03:20:30.0 I need it to look like this in Excel in a single cell. September 3, 2013 3:20 AM
Can this be done? Thanks
Assuming that pastes into Excel as an actual datetime string, then apply a custom number format to those cells:
Custom: MMMM D, YYYY H:MM AM/PM
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Go to Format, Format Cells, select Custom under Categories, and use this string for the format string:
mmmm d,yyyy h:mm AM/PM
SWEET! Thanks guys. That worked.
I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks