[gouse.aman]

Hi,

I have an excel file in which the second column consist of time which isn't in a correct format like 12:42:36 AM as 42:35.5 and I want it to be displayed as 00:42:36.000.

Data in the column is already present so I have to format it as described above.

Thanks in advance...

[FishMonger]

Why are you asking an Excel question in a Perl forum?

First hit on a simple google search:
How to Change a Cell's Number Format in Excel 2010 - For Dummies

[gouse.aman]

Originally Posted by FishMonger

Why are you asking an Excel question in a Perl forum?

First hit on a simple google search:
How to Change a Cell's Number Format in Excel 2010 - For Dummies

My dear,

The excel file must be formatted using Perl indeed.