too many different formats on excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Tried to change my cell format to number so as percentage sign does not
appear next to the number. However, unable to do it - dialog box keeps
showing <Too many different cell format>. My excel file is linked to many
other files.
 
hi

Right click on the cell that has the % value of number and then on the
general tab select general option then the value in % is converted to
equivalent decimal value.

haope this helps you
 

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 cell formats 2
"too many different cell format" 1
IF function says too many nested 1
stop error message "too many different cell formats" 1
How do I deal with a "Too many different cell formats". 1
Pop-up: "Too many different cell formats" 3
Copy/ paste Error " Too many different formats" 1
error message that says "too many different formats" Fix? 1

Back
Top