#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    11
    Rep Power
    0

    Formatting a column of excel


    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...
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Apr 2009
    Posts
    1,971
    Rep Power
    1225
    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
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    11
    Rep Power
    0
    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.

IMN logo majestic logo threadwatch logo seochat tools logo