Excel **

[Emily]

When input =450**3 , the cell becomes 450000

Interesting, why?

Thanks
Emily

[BlueCactus]

I've not seen that before, but it looks to be the same as typing =450e3

[stdz]

It means:


450 times 10 to the Power of 3

[Emily]

I've not seen that before, but it looks to be the same as typing =450e3

450e3 is shown as 4.50E+05

[Paleo]

450e3 is shown as 4.50E+05

Hi Emily,

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

[Bob Phillips]

450e3 is shown as 4.50E+05

But it also shows 450000 in the formula bar.

[BlueCactus]

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]

Sorry,
It's my mistake, I only typed 450e3 instead of =450e3
=450e3 shows 450000