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: 14
Default Numbers turn into something different after I push enter

Hi there!
First let me start off by saying that I know nothing about Excel, so this
may sound really simple to allot of you.
I'm using Excel 2002. I'm trying to enter a number into a spread sheet that
someone else created. The number is 292607312009. But when I tab over, the
number changes to 2.92607E+11!!! How do I get the number not to change to
something else?
Thanks,

 
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
In Excel - I want cell to turn green when enter Yes & Red for no? Mounty Excel Discussion (Misc queries) 1 March 2nd 09 03:49 PM
To move automatically right or down at the push of tab or enter? John P. Adams Excel Worksheet Functions 2 February 16th 09 04:36 AM
Enter multiple numbers in a cell so total shows when enter keypres newbie Excel Worksheet Functions 2 August 19th 07 12:23 PM
Why does 100 turn into 1 when I enter it into a cell? Ashley Luo Excel Discussion (Misc queries) 3 October 15th 06 11:51 PM
how do I turn ON auto REcalculate for formulas if new data enter? Mark Excel Worksheet Functions 1 January 19th 06 03:19 AM


All times are GMT +1. The time now is 02:56 PM.

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"