how to enter multipliers in excel

  • Thread starter Thread starter Calador
  • Start date Start date
C

Calador

Instead of tying in 3*10^3 for 3000. whats the shortcut to do this with
regards to the scientific calculator where you have the 'E' button right
beside the Ans button. That 'E' button represents x10^*, where * is any
integer.

For an example. How do you type 3.35Km? do you have to do it like
(3.35*10^3)m?
 
Calador said:
Instead of tying in 3*10^3 for 3000. whats the shortcut to do this with
regards to the scientific calculator where you have the 'E' button right
beside the Ans button. That 'E' button represents x10^*, where * is any
integer.

For an example. How do you type 3.35Km? do you have to do it like
(3.35*10^3)m?
Click to expand...


You can format the cell to "scientific" - then when you type in "3000" the
cell shows "3.00E+03"
 
Hmm that is interesting... so if i change that cell to scientific then i can
type 3000 as 3E+3 and do maths that way without having to put brackets? ill
give it a go though.
 
Or you can just type in 3E3, which is what I think the OP was asking.
3.35E3 is of course longer to type than 3350.
 
You do not need to format the cell. You can type 3E3 and Excel will display
3.00E+03
best wishes
 
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
 
Calador --

Just do the reverse of what's been described. Format the cells to number
(perhaps 0 decimals with a comma separator). Then, when you type in 3E3, it
shows up as 3,000.

HTH
 
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
 
Back
Top