+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Help to custom format number with text

  1. #1
    Registered User
    Join Date
    07-10-2008
    Location
    West Palm Beach
    MS-Off Ver
    2007
    Posts
    41

    Talking Help to custom format number with text

    I've got several spreadsheets that I must re-do quarterly. The last column is a sum of hours and minutes from several other spreadsheets. That's another issue entirely. Right now the individual types in 8hr15m. Can someone help me with a custom format so that when she types it in, the text hr (space) m is already there? I'd like her to be able to just type in the numbers on a keypad. Thanks
    Last edited by scarames; 03-25-2011 at 09:39 AM.

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Help to custom format number with text

    Try this:

    #"hr "00"m" or 0"hr "00"m"
    Last edited by Cutter; 03-24-2011 at 05:17 PM.

  3. #3
    Registered User
    Join Date
    07-10-2008
    Location
    West Palm Beach
    MS-Off Ver
    2007
    Posts
    41

    Thumbs up Re: Help to custom format number with text

    You're a genius! Thanks so much. Works like a charm. Wow, sure saved alot of time.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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