Hello,
Can anybody please help me with the following formatting of a cell:
Suppose I have a number i.e.: 0,00055 in excel you can use scientific format i.e.: 5,50E-04
But I would like to see it like this: 0,55E-03 can this automatically been done?
So for instance 0,00105 will become: 1,05E-03
Well, the closest I came up with is:
##0.00E+00
This is typically called 'Engineering' format. It forces the number after the E to be a multiple of 3 and to always have the left hand number be >=1. I think this is what you are looking for, but note that 0.55E-3 is not Engineering format, it would become 550.0E-06.
To get something that matches your first example (but not your second):
"0".##0E+00
Last edited by Pauleyb; 05-27-2014 at 03:44 PM.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Thanx for helping,
Using you're suggestion: ##0.0E+00 results in 12E4 for 0,0012.
I wish it would become: 1,20E-3 and for e.g. 0,00085 0,85E-3.
Any tips?
Onno
Maybe you need to change the period to a comma.
##0,00E+00
For me, 0.0012 does become 1.20E-03, but .00085 becomes 850.00E-06 (which matches engineering notation).
Hi, The , make sence and the first example 0,012 works but the second not.
Oops I really wish to see 0,00085 like this 0,85E-3
Thanx for helping me
Hi Onno,
I came up with a customized function that should display numbers the way you want. If you use the function, you may want to place the original numbers in a hidden column or hidden row.
I do not suggest using this function for calculations, because several siginficant digits of resolution may be lost due to rounding. See the attached file which implements the following code.
Lewis
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks