Solved

Comma Style Not Available

Posted on 2001-08-09
5
278 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 100 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

830 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