format cells (2002 sp2)

Topic

New Reply

Hi,
When I enter a number in a worksheet Excel formats it as 0.000000n.
Even when I format the cell a number with two decimals and I put in a 1, the outcome is 0.00
When I take the worksheet to Excel 97 on the same PC the numbers are still the same.
But when I put in a new number or modify the number already put in, the correct format follows.
Like when I put in a 1 in the example above the outcome will be 1.00
What’s happening? TIA

Reply | Quote

Replies

It sounds like you have a VBA routine in class module for the change event that is changing all input to be 0. Try the things that Jan Karel Pieterse suggests in this Star Post.

Reply | Quote

It sounds like you have a VBA routine in class module for the change event that is changing all input to be 0. Try the things that Jan Karel Pieterse suggests in this Star Post.

Reply | Quote

Hi,
If you look under Tools-Options and select the Edit tab, is the Fixed Decimals option checked? If so, uncheck it and the spreadsheet should then work ok.
Hope that helps.

Reply | Quote

Hey Rory the Pelvis ,
That’s it!!!
Simple but effictive, thanx.
Any idea how it was checked, because I can hardly imagine it is checked by default.
And this user is one that wouldn’t dare clicking on anything beyond input in cells.
Nevertheless: Fixed Decimals have left the building.

Reply | Quote

Hey Rory the Pelvis ,
That’s it!!!
Simple but effictive, thanx.
Any idea how it was checked, because I can hardly imagine it is checked by default.
And this user is one that wouldn’t dare clicking on anything beyond input in cells.
Nevertheless: Fixed Decimals have left the building.

Reply | Quote

Hi,
If you look under Tools-Options and select the Edit tab, is the Fixed Decimals option checked? If so, uncheck it and the spreadsheet should then work ok.
Hope that helps.

Reply | Quote