Rounding in Excel

[DoppiaV]

Hi all,
I am looking for a way to automate this into a formula or something.. now I have this covered with a lot of formulas within conditional formatting but am looking for a better solution to put it in one spreadsheet so everybody can use just one file.

After measuring we get a lot of results (in the image the numbers in the white cells as a example of how the results may appear) and I want it to be shown as the numbers in the Column with the yellow cells. Does someone know a formula / solution to get this done?

 

[JamesCanale]

Stole half of this from ExcelJet

MrExcelPlayground23.xlsx
	A	B
1	0.00255	0.0026
2	0.0255	0.026
3	0.255	0.26
4	2.55	2.6
5	25.5	26
6	255	255
7	2550	2550
8	25500	25500
9	255000	255000
10	2550000	2550000
11	25500000	25500000
12	255000000	255000000
13	2550000000	2550000000
14	25500000000	25500000000
Sheet6

Cell Formulas
Range	Formula
B1:B14	B1	=ROUND(A1,MAX(0,2-(1+INT(LOG10(A1)))))
A2:A14	A2	=A1*10

 

[DoppiaV]

Mr.James,
Formula works like a charm, thanks!
On the right side in white the outcome of the formula
Is there also a way to have the outcome minus al the zeros so the answer will looks like the numbers in yellow?

 

[DoppiaV]

Mr.James,
Formula works like a charm, thanks!
On the right side in white the outcome of the formula
Is there also a way to have the outcome minus al the zeros so the answer will looks like the numbers in yellow?

View attachment 113024

putting the General Format will give the answer only with the largest number it wil return 2,55E+11. I would like there also the full number