PDA

View Full Version : [SOLVED:] 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.
Bob Phillips
05-20-2005, 07:17 AM
450e3 is shown as 4.50E+05
But it also shows 450000 in the 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