how to enter multipliers in excel
 

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?

how to enter multipliers in excel
 

"Calador" wrote in message
...
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"

how to enter multipliers in excel
 

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.

"Gordon" wrote:

"Calador" wrote in message
...
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"

how to enter multipliers in excel
 

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.
--
David Biddulph

"Gordon" wrote in message
...
"Calador" wrote in message
...
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"

how to enter multipliers in excel
 

You do not need to format the cell. You can type 3E3 and Excel will display
3.00E+03
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Calador" wrote in message
...
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.

"Gordon" wrote:

"Calador" wrote in message
...
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"

how to enter multipliers in excel
 

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

how to enter multipliers in excel
 

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

"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

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