LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Number automatically divided by 100, why?

When i key a random number into a cell (in MS Excel 2007)

the number will automatically divided by 100

for example:
if i key in 2000 and press ENTER, it will become 2 immediately

if i key in 50 and press ENTER, it will become 0.5 immediately


I've checked the data format. the format is "GENERAL".


Something wrong with the settings?
 
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
Number entered in cell getting always divided by 100 ! Dipen Setting up and Configuration of Excel 5 August 28th 08 03:28 PM
numeric entered automatically divided 100! Anastasia Excel Discussion (Misc queries) 1 March 31st 08 11:36 AM
All number inputs are divided by 100 ? davor Setting up and Configuration of Excel 2 March 24th 06 01:05 AM
numbers in cells are automatically divided by 100. Not a format s. Surveyor Excel Worksheet Functions 1 February 22nd 05 04:30 PM
Typed number is always divided by 100 after pressing enter RF dude Excel Discussion (Misc queries) 2 January 28th 05 02:47 AM


All times are GMT +1. The time now is 12:27 AM.

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

About Us

"It's about Microsoft Excel"