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"