"Too Many Different Cell Formats"

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
 
K

KLassman

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
 
B

BrianB

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)
 
Top