format cells: decimal or integer needed

[tedleyvt]

When I try to fromat a cell and want to change the
category under the number tab I get an error message that
tells me "Your entry cannot be used. An integer or decimal
may be required." Deciaml places is highlighted but when I
enter any number in this field I get the same error
message. I have to right click the title bar of the
Format Cells window to close it. Sometimes I then get an
Application Error- Error access violation(0xc0000005).
Address:0x308047fe. How can I get rid of this bug?

 

[Dave Peterson]

I'm not sure if this will work.

But I tried this.

I used a macro to format my cell.

Option Explicit
Sub testme01()
Selection.NumberFormat = "0.00000000000000000000000000000000000000000000"
End Sub

This numberformat wouldn't be valid via the user interface.

When I went to the Format|Cells|Number tab|Number category, I saw that the
number of decimals was 44 for that selection.

But in my tests, I could change it manually with no crashes.

Since you're having trouble, maybe you could use a macro to change the
numberformat to see if that helps.

Select your cells and run this:
Option Explicit
Sub testme01()
Selection.NumberFormat = "0.00"
End Sub

Then back to Format|Cells to see if xl crashes.

With a little luck and plenty of good living, maybe it'll work????