| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Unix date to mmddyyyy:hr:min:sec format within Excel
I need to convert a column full of numbers representing date in Unix format
to the Windows date mmddyyyy:hh:mm:ss format. Can anyone provide me a macro which can do this for a column full of data? A sample of the data (in Unix Date format) is listed below: 1181846741 1181930850 1182017262 1182096202 1182182688 1182269074 1182355470 1182441813 1182528209 1182614575 1182731309 1182787489 1182873806 1182960243 1183046665 1183133077 1183219376 1183305815 1183392260 1183478655 1183565047 1183651427 1183737883 1183824182 1183910610 1183997155 1184083549 1184169943 1181846625 1181846741 Thanks in advance for your help regards PiyushAg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting US Date Format | Excel Worksheet Functions | |||
| Converting date format | Excel Discussion (Misc queries) | |||
| Converting to date format | Excel Discussion (Misc queries) | |||
| Excel keeps converting text to date format | Excel Discussion (Misc queries) | |||
| Converting a date in Excel 2002 to a Year/Quarter format | Excel Worksheet Functions | |||
Threaded Mode
