values I input into Excel automatically go to a decimal value 
Author Message
 values I input into Excel automatically go to a decimal value

I opended EXCEL XP version, which I have been using for over a year,
and started putting some values into a spreadsheet.  Every value I
entered would go to a decimal, for example, I entered 4 and it became
.0004

I ran a virus scan and found nothing, I also turned my PC on/off and
had the same problem.

Has anyone seen this before?

Bill T.



Sat, 06 Aug 2005 15:01:12 GMT  
 values I input into Excel automatically go to a decimal value
Go to Tool > Options > Edit tab and uncheck the boxed next to "Fixed
decimal".

--
HTH,
Laura Cook
Appleton, WI


Quote:
> I opended EXCEL XP version, which I have been using for over a year,
> and started putting some values into a spreadsheet.  Every value I
> entered would go to a decimal, for example, I entered 4 and it became
> .0004

> I ran a virus scan and found nothing, I also turned my PC on/off and
> had the same problem.

> Has anyone seen this before?

> Bill T.



Sat, 06 Aug 2005 15:16:42 GMT  
 values I input into Excel automatically go to a decimal value

Quote:
>I opended EXCEL XP version, which I have been using for over a year,
>and started putting some values into a spreadsheet.  Every value I
>entered would go to a decimal, for example, I entered 4 and it became
>.0004

>I ran a virus scan and found nothing, I also turned my PC on/off and
>had the same problem.

>Has anyone seen this before?

>Bill T.

Tools/Options/Edit
Clear "Fixed Decimal"

--ron



Sat, 06 Aug 2005 15:25:06 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Does input box value = cell value?

2. How can I change some values from decimal point to decimal comma

3. Lookup values based on an input value

4. Storing Decimal Values versus Displaying Decimals ..

5. Automatically Set Checkbox value based on a combo box value

6. ? Automatically setting a value based on value in another field

7. reading values from another table to create a default value automatically

8. VB Converting Excel % Values to Decimal

9. Problems with entering decimal values into excel 97 with Visual Basic

10. Input box method - value for input of date


 
Powered by phpBB® Forum Software © phpBB Group