Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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,

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,276
Default Numbers turn into something different after I push enter

Hi,
cell has to be format as a text, right click on the cell, format cells,
number, text, then enter the number again

"Jennie" wrote:

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,

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default Numbers turn into something different after I push enter

--If it is all 12 digit numbers .Right click the cells before entering the
numbers and custom format Type 12 zeroes

000000000000

--If you have more than 15 digits then pre format the cells to text and then
enter the numbers
Or
Prefix the numbers with a apostrophe
'1234567890123456
(Remember these are in text format)
If this post helps click Yes
---------------
Jacob Skaria


"Jennie" wrote:

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,

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Numbers turn into something different after I push enter

The number is the same (in math terms). It's just how it's displayed that's
different.

Kind of like the difference between:

January 3, 2009
and
03-January-2009

Try changing the numberformat to something nicer (Number with 0 decimals???).

You may have to widen the column, too.

Jennie wrote:

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,


--

Dave Peterson
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
In Excel - I want cell to turn green when enter Yes & Red for no? Mounty Excel Discussion (Misc queries) 1 March 2nd 09 04: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 05: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 04:19 AM


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