• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

number format error message

Hello all,

Can someone tell me what these error messages mean and how can I fix them?

"No more custom number formats can be added!"
This error message appears when I first open an Excel file; I have to click OK several times before it goes away.

"File Error, Some number formats may have been lost"
After clicking OK on the first error message, then I get this one I click OK once and it goes away, then I can work on my file.

The messages only appear when I open an existing file; they do not appear with a new file.
Can someone please help?

TIA, Jovix
0
Jovix
Asked:
Jovix
1 Solution
 
jboddyCommented:
Which vesion of Excel?
Most seem to favour this solution:-
"You receive these error messages if the Symbol box in the
International - Currency Format dialog box is empty."
Will re-post as an answer if it solves the problem.

0
 
vboukharCommented:
Did this messages appear on every files, or just on some of them?
Maybe this workbook really contains custom number formats?
0
 
carttiCommented:
In this file, choose the Format Cells option. In the Number category, check the sub-category custom. If it is a huge list of formats, the error message was referring to the size of this list. If you delete the unnecessary ones and then save the file, you should no longer get those error messages.
The reason why you don't get these messages with a new workbook is because settings which include custom number formats are saved with the file. Basically Excel is having memory problems storing all those formats which might explain the loss of some of them.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now