Excel Decimal place

[ping0775]

Hi, for excel is the figure is 0.1, 150,
i can convert it automatically to 2 decimal in the format ribbon.
for example.
150 = 150.00
0.1 = 0.10


but if the value is 0.175
0.1857
the decimal place more than 2, how to remain the value
how to remain the third value without auto round up to 0.18

1. would like to auto round up if decimal place is less than 2
2. would like to keep the decimal if the value is more than 3
please assist

 

[SanjayGMusafir]

Check if this works for you -

All Records.xlsb
	C	D
4	0.1875	0.1875
5	0.15	0.15
Sheet1

Cell Formulas
Range	Formula
D4:D5	D4	=IF(LEN(C4-INT(C4))>4,TEXT(C4,"#,##0.0000"),TEXT(C4,"#,##0.00"))