| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NUMBERS NOT TYPING CORRECTLY
WHEN TYPING IN A CELL A # THEY ARE APPEARING LIKE THIS 5.63663E+13
AFTER I PRESS ENTER- HOW DO I FIX THIS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NUMBERS NOT TYPING CORRECTLY
Expand the column width...
-- HTH... Jim Thomlinson "cb" wrote: WHEN TYPING IN A CELL A # THEY ARE APPEARING LIKE THIS 5.63663E+13 AFTER I PRESS ENTER- HOW DO I FIX THIS |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NUMBERS NOT TYPING CORRECTLY
Set the number format to something other than scientific.
-- TedMi |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NUMBERS NOT TYPING CORRECTLY
whatever all have said nothing is working!!
"Jim Thomlinson" wrote: Expand the column width... -- HTH... Jim Thomlinson "cb" wrote: WHEN TYPING IN A CELL A # THEY ARE APPEARING LIKE THIS 5.63663E+13 AFTER I PRESS ENTER- HOW DO I FIX THIS |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NUMBERS NOT TYPING CORRECTLY
Elect to format the Cell to display in the desired manner.
Right click on the cell, and pick Format cell cb wrote: whatever all have said nothing is working!! "Jim Thomlinson" wrote: Expand the column width... -- HTH... Jim Thomlinson "cb" wrote: WHEN TYPING IN A CELL A # THEY ARE APPEARING LIKE THIS 5.63663E+13 AFTER I PRESS ENTER- HOW DO I FIX THIS |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NUMBERS NOT TYPING CORRECTLY
Have you tried formatting to SpecialZip Code?
Gord Dibben MS Excel MVP On Thu, 27 Mar 2008 14:44:00 -0700, cb wrote: whatever all have said nothing is working!! "Jim Thomlinson" wrote: Expand the column width... -- HTH... Jim Thomlinson "cb" wrote: WHEN TYPING IN A CELL A # THEY ARE APPEARING LIKE THIS 5.63663E+13 AFTER I PRESS ENTER- HOW DO I FIX THIS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting a formula when typing long numbers | Excel Discussion (Misc queries) | |||
| Numbers not adding together correctly | Excel Worksheet Functions | |||
| How do I get consecutive numbers without typing them in manually | Excel Discussion (Misc queries) | |||
| How to print from consecutive numbers in excel w/o typing all? | Excel Worksheet Functions | |||
| Formatting: when typing the numbers "2004" then a period or simili | Excel Discussion (Misc queries) | |||
Linear Mode
