28 Jan 2009 at 12:20 #1 Noto Noto Associate Joined 1 Dec 2002 Posts 1,884 Hi there its silly question time! I have a formula in a cell and the result is 1.4 E+07. Is there a way i can get the cell to show 14 E+06 ? Thanks in adv!! -Noto
Hi there its silly question time! I have a formula in a cell and the result is 1.4 E+07. Is there a way i can get the cell to show 14 E+06 ? Thanks in adv!! -Noto
28 Jan 2009 at 12:53 #2 Tomsk Tomsk Soldato Joined 18 Oct 2002 Posts 5,235 Location Overground, underground.. Custom number format Code: [<0.001]##0.00E+0;[<1000] #0.00;##0.00E+0 I didn't work this out. Found it on the intenet a while back
Custom number format Code: [<0.001]##0.00E+0;[<1000] #0.00;##0.00E+0 I didn't work this out. Found it on the intenet a while back
29 Jan 2009 at 14:39 #3 Tomsk Tomsk Soldato Joined 18 Oct 2002 Posts 5,235 Location Overground, underground.. I've been playing around and it's built in to Excel (2003) list of custonm formats already Code: ##0.0E+0
I've been playing around and it's built in to Excel (2003) list of custonm formats already Code: ##0.0E+0
29 Jan 2009 at 15:51 #4 Burnsy2023 Burnsy2023 Man of Honour Joined 17 Nov 2003 Posts 36,747 Location Southampton, UK Have you tried widening the column width?
