| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers
I am new to Excel,using the 2002 edition. I 'm using it as a inventory of my
radio tubes.Some of the #'s use letters and #. Now when I go to type in 2E26,I get this 2.00E+26 what do I do to correct this thanks John Bauman |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
numbers
It thinks you are typing in a number. either format the cell to text or type
an ' then the number -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Baumanjohn" wrote: I am new to Excel,using the 2002 edition. I 'm using it as a inventory of my radio tubes.Some of the #'s use letters and #. Now when I go to type in 2E26,I get this 2.00E+26 what do I do to correct this thanks John Bauman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
Linear Mode
