Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Comma Style Not Available

Posted on 2001-08-09
5
Medium Priority
?
283 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

715 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