Round function for .20

[sksanjeev786]

Hi Team,

I wrote function ROUND(B1,2) but I am not getting 0 at the end as I need .20 but getting 0.2 only

HP_China.xlsx
	A	B	C	D	E
1	Has the best value considering its specs (video card, CPU, RAM, etc.)	20%		Has the best value considering its specs (video card, CPU, RAM, etc.)0.2
2	Is best for gaming	20%		Is best for gaming0.2
3	Is a brand that represents my values	20%		Is a brand that represents my values0.2
4	Brings the most exciting features	20%		Brings the most exciting features0.2
5	Is a brand I can trust	19%		Is a brand I can trust0.19
6	Offers products I am proud to be seen with	19%		Offers products I am proud to be seen with0.19
7	Is associated with eSports	19%		Is associated with eSports0.19
8	Offers products with designs that appeal to me	18%		Offers products with designs that appeal to me0.18
9	Is designed by gamers	18%		Is designed by gamers0.18
10	Is recommended by gamers	18%		Is recommended by gamers0.18
Sheet2

Cell Formulas
Range	Formula
D1:D10	D1	=A1&ROUND(B1,2)

Thanks.
Sanjeev

 

[Peter_SSs]

Try

=A1&TEXT(ROUND(B1,2),"0.00")

 

[sksanjeev786]

Try

=A1&TEXT(ROUND(B1,2),"0.00")

Thank you, Peter for your help

Just wanted to check can we change this to value data as of now it is coming in Text formate and when I wrote Value function again it came to .2 only

If it is possible otherwise no issue I will do manually

HP_China.xlsx
	A	B	C
1	Has the best value considering its specs (video card, CPU, RAM, etc.)	20%	0.2
2	Is best for gaming	20%	0.2
3	Is a brand that represents my values	20%	0.20
4	Brings the most exciting features	20%	0.20
Sheet2

Cell Formulas
Range	Formula
C1:C2	C1	=VALUE(TEXT(ROUND(B1,2),"0.00"))
C3:C4	C3	=TEXT(ROUND(B3,2),"0.00")

Thank you once again.
Sanjeev.

 

[Peter_SSs]

In the first post you were combining the value with text so it must be in text format.

You now appear to be wanting it in a cell by itself and not combined with text. In that case just use =ROUND(B1,2) and format the column as Number with 2 decimal places.

 

[sksanjeev786]

In the first post you were combining the value with text so it must be in text format.

You now appear to be wanting it in a cell by itself and not combined with text. In that case just use =ROUND(B1,2) and format the column as Number with 2 decimal places

Thanks, Peter I just change the number formate.

Thanks again for your time and hard work

 

[Peter_SSs]

You're welcome.