+ Reply to Thread
Results 1 to 4 of 4

Making my own Category under Format Cells...

  1. #1
    Registered User
    Join Date
    07-16-2010
    Location
    Buffalo, NY
    MS-Off Ver
    Excel 2004
    Posts
    2

    Lightbulb Making my own Category under Format Cells...

    I would like to create a category that would allow me to do the following:

    I'm working with number in Mod12. If I type numbers (or if numbers are put there by formulas) 1 through 9, I want them displayed as such. If type the number 10, I would like it to be displayed as "t" as well as number 11 to be displayed as "e". This is similar to when you type 5 into a cell that is styled as currency, "$5.00" is displayed. I don't want the value of the cell to change so "t" and "e" still function as 10 and 11, respectfully.

    Any help would be appreciated!

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: Making my own Category under Format Cells...

    Welcome to the forum.

    Try [>10]"e";[>9]"t";0
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Making my own Category under Format Cells...

    You might also find the page of interest/help: Custom Number Formats
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  4. #4
    Registered User
    Join Date
    07-16-2010
    Location
    Buffalo, NY
    MS-Off Ver
    Excel 2004
    Posts
    2

    Re: Making my own Category under Format Cells...

    Thanks so much! Works like a charm! A musician is happy with his twelve tone matrix!

+ Reply to Thread

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