how to enter multipliers in excel

[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?

 

[Gordon]

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?

You can format the cell to "scientific" - then when you type in "3000" the
cell shows "3.00E+03"

 

[Calador]

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.

 

[David Biddulph]

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.

 

[Bernard Liengme]

You do not need to format the cell. You can type 3E3 and Excel will display
3.00E+03
best wishes

 

[Calador]

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

 

[pdberger]

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

 

[Gord Dibben]

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