Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mohammad
 
Posts: n/a
Default My excel2000 divide numbers per 10 why?

In every old or new sheet and cell with general or number format when i type
a number, excel divide it per 10. For example when i type 80 after enter, i
see 8 in that cell.
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

Use Tools | Options; open the Edit tab; uncheck the box called Fixed
Decimal....

best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"mohammad" wrote in message
...
In every old or new sheet and cell with general or number format when i
type
a number, excel divide it per 10. For example when i type 80 after enter,
i
see 8 in that cell.



  #3   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

Tools|Options and look on the Edit tab. Uncheck the fourth item down
(Fixed decimal Places)

Jerry

mohammad wrote:

In every old or new sheet and cell with general or number format when i type
a number, excel divide it per 10. For example when i type 80 after enter, i
see 8 in that cell.


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
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
I enter numbers and they are stored as text burkeville Excel Discussion (Misc queries) 5 December 3rd 04 02:59 AM
How do I take two columns of sequential numbers and insert spaces cmrdjr Excel Discussion (Misc queries) 5 December 2nd 04 11:35 PM
adding only positive numbers Jacob Excel Discussion (Misc queries) 2 November 30th 04 01:24 AM
Negative Numbers Glenda Excel Discussion (Misc queries) 3 November 26th 04 03:06 PM


All times are GMT +1. The time now is 05:59 AM.

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"