Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 23rd 09, 06:30 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2009
Posts: 2
Default excel 2003: how do I fix: "Style 'Comma' not found"

I cannot use any of the format functions in certain excel files that I get
from other uses. How can I fix this?

  #2   Report Post  
Old August 23rd 09, 06:36 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 8,520
Default excel 2003: how do I fix: "Style 'Comma' not found"

Are you sure the work sheet is not protected...

If this post helps click Yes
---------------
Jacob Skaria


"jrp9206" wrote:

I cannot use any of the format functions in certain excel files that I get
from other uses. How can I fix this?

  #3   Report Post  
Old August 23rd 09, 06:45 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2009
Posts: 2
Default excel 2003: how do I fix: "Style 'Comma' not found"

Hi Jacob - no it doesn't appear to be. I can change the formatting if I take
the long way of clicking Format, cells,..... but I cannot format cells using
the standard Comma, %,... buttons - nor can I format using my macros. ANy
thoughts?

"Jacob Skaria" wrote:

Are you sure the work sheet is not protected...

If this post helps click Yes
---------------
Jacob Skaria


"jrp9206" wrote:

I cannot use any of the format functions in certain excel files that I get
from other uses. How can I fix this?

  #4   Report Post  
Old August 23rd 09, 11:03 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default excel 2003: how do I fix: "Style 'Comma' not found"

You can change or Create or delete the Comma style. And I bet that's what
happened to the person sending you the file.

You can do it manually:

Format|Style (in xl2003 menus)
or
Home tab|Style group|Cell Styles icon (on the xl2007 ribbon)

Change or create the comma style to what you want.

Or......

Start a new workbook.
Open the offending workbook.

With the offending workbook active, click on Format|Style
Click on the Merge button
Select the new workbook
and click ok

Since styles live in workbooks, you'll have to do this to every workbook that
lost its style.



jrp9206 wrote:

I cannot use any of the format functions in certain excel files that I get
from other uses. How can I fix this?


--

Dave Peterson
  #5   Report Post  
Old March 25th 16, 07:09 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2016
Posts: 1
Default excel 2003: how do I fix: "Style 'Comma' not found"

On Monday, August 24, 2009 at 3:33:02 AM UTC+5:30, Dave Peterson wrote:
You can change or Create or delete the Comma style. And I bet that's what
happened to the person sending you the file.

You can do it manually:

Format|Style (in xl2003 menus)
or
Home tab|Style group|Cell Styles icon (on the xl2007 ribbon)

Change or create the comma style to what you want.

Or......

Start a new workbook.
Open the offending workbook.

With the offending workbook active, click on Format|Style
Click on the Merge button
Select the new workbook
and click ok

Since styles live in workbooks, you'll have to do this to every workbook that
lost its style.



jrp9206 wrote:

I cannot use any of the format functions in certain excel files that I get
from other uses. How can I fix this?


--

Dave Peterson




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003: Conditional Formatting using "MIN" & "MAX" function MMangen Excel Discussion (Misc queries) 2 September 16th 08 07:13 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
In Excel 2003 is there a way to prevent "Save As" and "Print"? lucky2000 Excel Discussion (Misc queries) 3 April 26th 07 02:49 PM
Puzzled by statement about R1C1 style in "Escape from Excel Hell" [email protected] Excel Discussion (Misc queries) 3 April 12th 06 01:04 AM
using % button gives error "percent style not found" Can I reset? Light Excel Discussion (Misc queries) 3 March 16th 06 12:18 PM


All times are GMT +1. The time now is 04:54 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017