I want to be able to change decimal answers in excel to the power of, e.g.: 0.006 to 6 x10-3
R Rosco Feb 24, 2007 #1 I want to be able to change decimal answers in excel to the power of, e.g.: 0.006 to 6 x10-3
V Vergel Adriano Feb 24, 2007 #2 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, 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.
J john Feb 24, 2007 #3 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)
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)
