"Too Many Different Cell Formats"

  • Thread starter Thread starter KLassman
  • Start date Start date
K

KLassman

Can anyone tell me what this means and how I can fix whatever is causin
it? I'm simply trying to change some cells from no decimals t
having decimals. I did test other worksheets in the same workboo
and I get the same message there, too. This workbook I'm working i
has probably 20 different worksheets . . . some are graphs, some ar
copies of work in other folders. Thanks in advance for any help
 
Thank you for your response. I have copied off the info and will tr
it when I return to work tomorrow. I'm not familiar with VBA macro
. . . so will hold off on that unless the other information doesn'
work for me
 
You have to go to Format/Cells/Number/Custom and delete some format
(some of them are built in and cannot be deleted - yes, the mor
rubbish-looking ones)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Too many different call formats" error msg 1
Running Sum of cell in many spreadsheets 1
Too Many Different Cell Format 3
Code to format cells on several worksheets 2
Find/Replace Numbers stored as Text drops zeros 1
Problem with Excel rounding numbers 5
Excel Chart - Too many data points in Series? 1
Recover .xls file with "Too many different cell formats" error 1

Back
Top