Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

How do I add a custom number format in Excel 2003

How do I add a custom number format in Excel 2003 ?  I go to Format, Cells, Custom, and from the category list, I try to type in a new list, but nothing happens.  I dont see an option to save a new list either.  There is a button to delete existing lists, but not to create or save one.

I am trying to make a custom list that has "Bad";"Fair";"Good";"Great";"Excellent";"Perfect"

When I try to edit the existing:    "Yes";"Yes";"No",   or to just begin entering a new set, I get the error below:


What am I doing wrong?
Thanks.
Excel-Number-Format-Error-01.JPG
0
FirstDownMage
Asked:
FirstDownMage
  • 3
  • 2
  • 2
1 Solution
 
jppintoCommented:
You can create the Custom format but how will Excel know what name to give to the value presented on a cell? For instance, what should be the value of the cell for Excel change it to "Good"?

jppinto
0
 
FirstDownMageAuthor Commented:
Could you rephrase what you just said, I'm not sure I understand the last sentence.  Excel shouldn't change anything if I enter Good.   You know how a Yes / No box will allow you to enter in only, yes or no.  I'm trying to create that, only with 6 different options instead of 2.
0
 
jppintoCommented:
I'm not following your question now...You want to create a custom format, right? In that custom format you want to include 6 Types, right?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
FirstDownMageAuthor Commented:
Correct.  The six values that could be entered / accepted would be:
"Bad";"Fair";"Good";"Great";"Excellent";"Perfect".
0
 
Chris BottomleyCommented:
Hello FirstDownMage,

Sounds like you may want data validation, instead of using a cell reference you could use a list but the principle is as shown here.

http://www.contextures.com/xldataval02.html#Apply

Regards,
Chris
0
 
Chris BottomleyCommented:
FirstDownMage,

Enter your list in the source box as:

Bad, Fair, Good, Great, Excellent, Perfect

chris_bottomley
0
 
jppintoCommented:
Do you need further assistance on this question?
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now