Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Griff
 
Posts: n/a
Default When I type 100 EXCEL changes it to 10. Why?

When I type numbers into my EXCEL sheets it reduces the number by 1 number. I
have changed the format of the cell multiple times in an effort to correct it
and nothing seems to work. I will type 20 and EXCEL will show 2. I changed
the number of decimal places and it still shows 2. Does anyone know how to
turn this feature off?
  #2   Report Post  
Nick
 
Posts: n/a
Default

select Tools - Options.
On the Edit tab make sure the Fixed Decimal option is not ticked.

Nick


"Griff" wrote in message
...
When I type numbers into my EXCEL sheets it reduces the number by 1
number. I
have changed the format of the cell multiple times in an effort to correct
it
and nothing seems to work. I will type 20 and EXCEL will show 2. I changed
the number of decimal places and it still shows 2. Does anyone know how to
turn this feature off?



  #3   Report Post  
RagDyeR
 
Posts: n/a
Default

<Tools <Options <Edit tab,

And *UNCHECK*
"Fixed Decimal Places".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Griff" wrote in message
...
When I type numbers into my EXCEL sheets it reduces the number by 1 number.
I
have changed the format of the cell multiple times in an effort to correct
it
and nothing seems to work. I will type 20 and EXCEL will show 2. I changed
the number of decimal places and it still shows 2. Does anyone know how to
turn this feature off?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
I get a program error when I download an excel template Ladybug Excel Discussion (Misc queries) 3 March 4th 05 01:02 AM
Opening an Excel file Sheldon Zaklow Excel Discussion (Misc queries) 0 March 3rd 05 11:29 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 12:32 PM
Excel: type "ACN" into a cell and you get "CAN" why? bacheb Excel Discussion (Misc queries) 3 January 11th 05 08:37 PM


All times are GMT +1. The time now is 04:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"