Results 1 to 6 of 6

changing formats of cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-19-2009
    Location
    Nambucca Heads NSW
    MS-Off Ver
    Excel 2007
    Posts
    125

    changing formats of cells

    hi need help with the following i have 1500 rows and around 15 columns to change

    format says 1.49-2

    I need it to say 01:49.2

    when I highlight it and go into format cells
    and change it to min:ss.0 it changes to the following 48:28.8

    i have included a file for you to see
    Attached Files Attached Files
    Last edited by Duckie; 04-30-2009 at 06:41 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1