Results 1 to 3 of 3

Excel 2007 : Help to custom format number with text

Threaded View

  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.

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