Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel - I want cell to turn green when enter Yes & Red for no? | Excel Discussion (Misc queries) | |||
To move automatically right or down at the push of tab or enter? | Excel Worksheet Functions | |||
Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
Why does 100 turn into 1 when I enter it into a cell? | Excel Discussion (Misc queries) | |||
how do I turn ON auto REcalculate for formulas if new data enter? | Excel Worksheet Functions |