Apr 9, 2021 #1 wmbb Technical User Jul 17, 2005 320 NL How can I display all values in a excel sheet as xxxE-10 Not just scientific notation but specific as E-10
How can I display all values in a excel sheet as xxxE-10 Not just scientific notation but specific as E-10
Apr 9, 2021 #2 combo Technical User Jan 1, 2003 4,176 PL If xxx is not fixed, you can cheat a little with custom format: 0,########## "E-10" combo Upvote 0 Downvote