See

http://www.mcgimpsey.com/excel/udfs/unixtoxltime.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"PiyushAg" wrote in message ...
|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