• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • 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
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
FirstDownMageAuthor Commented:
Correct.  The six values that could be entered / accepted would be:
"Bad";"Fair";"Good";"Great";"Excellent";"Perfect".
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
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 BottomleySoftware Quality Lead EngineerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

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