Hi guys,
I dont seem to find a post that solve this issue:
Applying one custom formatting formula to a list of number in order to round them to the first two significant digits
Example:
1,428,932.0000 --- 1,400,000
189,023.0000 --- 190,000
60,345.0000 --- 60,000
5,434.0000 --- 5,400
985 --- 990
57.24 --- 57
7.345 --- 7.3
etc
Thank you!
Hi nangys,
I don't think you can do this because you want to apply different rules to the same Column.
You could use =MID(A1,1,2) but this would only give you the first 2 characters which isn't what you need ...
Last edited by noboffinme; 02-20-2014 at 04:43 PM.
Remember you are unique, like everyone else
I will be interested to see other's responses. Being a scientist, the best I have found is to use scientific/exponential notation: 0.0E+0. When I specifically don't want scientific notation (and most Excel users probably don't), I have not found a good formatting solution.
I'm sure we could figure out a function solution that would be able to do this (maybe something like =VALUE(TEXT(A1,"0.0E+0")) that would convert the raw value to the desired rounded format.
Originally Posted by shg
This will be a tough 1, because you dont just want the 1st 2 values shown, you also want them rounded
This works for all but the last 1, working on that now...
=MROUND(A1,10^(LEN(INT(A1))-2))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
OK if you format that to numbers, 2 decimal places (or 1), with thousand seperators, that works for all of them
This formula seems to work pretty well for the tables that I'm using!!!
Thank you so much guys for all your answers.
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks