PDA

View Full Version : Excel **



Emily
05-19-2005, 11:47 PM
When input =450**3 , the cell becomes 450000

Interesting, why?

Thanks
Emily

BlueCactus
05-20-2005, 12:40 AM
I've not seen that before, but it looks to be the same as typing =450e3

stdz
05-20-2005, 03:32 AM
It means:


450 times 10 to the Power of 3

Emily
05-20-2005, 06:38 AM
I've not seen that before, but it looks to be the same as typing =450e3
450e3 is shown as 4.50E+05

Paleo
05-20-2005, 07:12 AM
450e3 is shown as 4.50E+05


Hi Emily,

if you type =450e3 at your spreadsheet you get 450000.

xld
05-20-2005, 07:17 AM
450e3 is shown as 4.50E+05
But it also shows 45000 in thre formula bar.

BlueCactus
05-20-2005, 07:23 AM
450e3 is shown as 4.50E+05
That's probably dependent on the way your cell formatting is set up. Unless you specify otherwise, Excel has a nasty habit of making its own mind up about these things.

Emily
05-20-2005, 08:38 AM
Sorry,
It's my mistake, I only typed 450e3 instead of =450e3
=450e3 shows 450000