Excel 97 numeric format

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

rxmpdf

Thread Starter
Joined
Mar 31, 2004
Messages
1
I run Excel 97 on a Windows 98 platform.

Some time ago, my numeric format default changed so that every number that I key in - no matter to what cell - appears to be formatted by default to equal 10% of the number that I actually keyed in, or as if it was default to one decimal point.

Thus, if I key in 4321, the figure that actually appears on the spreadsheet is 432.1.

In an attempt to correct this, I re-set the Format Numeric code to zero decimal places, to no avail. Previous spreadsheets with good data still have good data. It is only the NEW numeric data that has a default format of one decimal place.

I have also re-installed Microsoft Office 97, to no avail.

I have reinstalled Windows 98, to no avail.

My guess is that there is one field in the Registry where the "one decimal" default is somehow locked in, instead of defaulting to zero decimal points.

Suggestions?


rxmpdf
 
Joined
Aug 30, 2003
Messages
2,702
>> Suggestions?

#1 suggestion, always ; Tools -- Options -- Edit -- Fixed Decimals?

HTH,
Andy
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top