how to change decimal answers in excel to the power of

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rosco - 24 Feb 2007 20:43 GMT

I want to be able to change decimal answers in excel to the power of, e.g.:
0.006 to 6 x10-3

Reply to this Message

Vergel Adriano - 24 Feb 2007 20:51 GMT

Rosco,

Try this:

Format->Cells. In the Number tab, Category list, select Custom. Then enter
for Type:

0 "x10 "E+0

There doesn't seem to be a way to get rid of the "E" though.

> I want to be able to change decimal answers in excel to the power of, e.g.:
> 0.006 to 6 x10-3

Reply to this Message

john - 24 Feb 2007 20:54 GMT

format the cells to scientific

Signature

John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

> I want to be able to change decimal answers in excel to the power of, e.g.:
> 0.006 to 6 x10-3

Reply to this Message