Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Comma Style Not Available

Posted on 2001-08-09
5
Medium Priority
?
284 Views
Last Modified: 2012-05-04
I'm running Excel 2000 v 9.0.2720.

When I highlight a cell, then click on the comma on the tool bar, I get an error message that says, "Style 'comma' not found".  The same thing happens for the $ and the %.

What happened?  How can I fix it?
0
Comment
Question by:aintnorock
  • 3
  • 2
5 Comments
 
LVL 8

Expert Comment

by:starl
ID: 6369452
take a look in Format - Style - do you have any styles in there?
0
 
LVL 8

Accepted Solution

by:
starl earned 400 total points
ID: 6369474
if not, your styles may have been deleted. you can recreate them by adding them in. For example, to recreate the comma style
1. type comma in the name field
2. click on add
3. check the number box only (for me, they were all checked)
4. if you need to, modify the style
0
 

Author Comment

by:aintnorock
ID: 6369476
I looked at Format style, and only "normal" is showing.

I have been able to use the %, $, and comma styles before, but now they don't seem to be there.

thanks,
carl
0
 

Author Comment

by:aintnorock
ID: 6369555
Thanks.  that worked.  I wonder how they got deleted?

carl
0
 
LVL 8

Expert Comment

by:starl
ID: 6369636
don't know. is your template shared? did you create a new template? are you pointing to something other than the default template?

check - tools - options - alternate startup - anything listed there?
search for your xlstart folder - anything in there?
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question