how to change decimal answers in excel to the power of
I want to be able to change decimal answers in excel to the power of, e.g.:
0.006 to 6 x10-3 |
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 |
how to change decimal answers in excel to the power of
format the cells to scientific
-- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "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 |
All times are GMT +1. The time now is 09:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com