LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JohnO
 
Posts: n/a
Default Excel divides number by 10e6 unless followed by decimal point.

When I type a number into a cell Excel displays the number divided by
1,000,000 unless the number is followed by a decimal point. What can I do to
change this?


 
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
VARYING number of sheets in EXCEL Darrin New Users to Excel 3 February 22nd 05 03:07 PM
Excel formula divide list of #s by N to get a number above 40 JudyK Excel Discussion (Misc queries) 11 February 9th 05 08:51 PM
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 08:13 PM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 04:21 AM
Can Excel add a set percentage to a cell automatically when you type in a number Chris B. Excel Worksheet Functions 3 October 29th 04 07:08 PM


All times are GMT +1. The time now is 05:59 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"