Use below functions:
For date:
=TEXT(A1,"mm/dd/yyyy")
For time:
=TEXT(A1,"hh:mm:ss AM/PM")
A1 is the cell where the data (date and time) is stored.
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
________________________________
From: vinu <[EMAIL PROTECTED]>
To: MS Excel & VBA Macros <excel-macros@googlegroups.com>
Cc: [EMAIL PROTECTED]
Sent: Tuesday, 4 November, 2008 5:54:12 PM
Subject: $$Excel-Macros$$ Need help for the below issue.
Hi All,
I have a data like this in a single cell for eg A1 "11/4/2008
5:51:00 PM".
I need date in A2 cell and time in in A3 cell. How to do it. Plz
help me.
Thanks in advance.
From Chandigarh to Chennai - find friends all over India. Go to
http://in.promos.yahoo.com/groups/citygroups/
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
