how to change decimal answers in excel to the power of
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.
"Rosco" wrote:
I want to be able to change decimal answers in excel to the power of, e.g.:
0.006 to 6 x10-3
|