| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to enter multipliers in excel
Pre-format the cells to Number with no DP
Enter 3e3 and see what comes up. Excel 2003 returns 3000 Gord Dibben MS Excel MVP On Thu, 29 Nov 2007 14:14:01 -0800, Calador wrote: hmm my point is not to type 3E3 and show it as that. i would like to type out 3E3 and for it to show 3000. How do i go by that? instead of formatiing cell to show it as general or numerical and not scientific |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| Enter info in one sheet, auto enter in another based on one field | New Users to Excel | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
| enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
Threaded Mode
