| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Text numbers to time format
I have numbers (time) imported as text so I cannot simply format the cell to time. does anybody know a formula that will convert this to the following 130702 - to - 01:07:02 PM 093506 - to - 09:03:06 AM 101607 - to - 10:16:07 AM 123958 - to - 12:39:58 AM 225409 - to - 10:54:09 PM -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=503133 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert text to numbers | Excel Discussion (Misc queries) | |||
| convert numbers to text | Excel Discussion (Misc queries) | |||
| convert number to time format? | Excel Discussion (Misc queries) | |||
| How do you convert numbers as "text" to values for a long column . | Excel Discussion (Misc queries) | |||
| how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions | |||
Threaded Mode
