Convert Function

[ChrisHockley]

Guys,

I'm at a loss. I am using the convert formula successfully in an excel doc. However, 3/16 or 5/16 won't convert. I get some large number. Is there a way around this or do i just need to forget convert and just multiply by 28.35? Thanks all!

 

[DanteAmor]

I don't know exactly what you mean, but check the Precision as displayed option in Excel.

Click File > Options. Click Advanced, and then under When calculating this workbook, select the Set precision as displayed check box, and then click OK

 

[ChrisHockley]

I don't know exactly what you mean, but check the Precision as displayed option in Excel.

Click File > Options. Click Advanced, and then under When calculating this workbook, select the Set precision as displayed check box, and then click OK

Here's an example... the formula =CONVERT(AP1082,"ozm","g") changes the 1/8 to 3.5. But 3/16 is 1,286,132.8...

 

[Skyybot]

Book1
	A	B
1	Inches	mm
2	3/16	4.76
PP_Own

Cell Formulas
Range	Formula
B2	B2	=CONVERT(A2*1000,"in","m")

 

[ChrisHockley]

Book1
	A	B
1	Inches	mm
2	3/16	4.76
PP_Own

Cell Formulas
Range	Formula
B2	B2	=CONVERT(A2*1000,"in","m")

That seems to have made it a 1000 times worse...lol. Maybe I'm misunderstanding.

 

[Skyybot]

Make sure that you Format fractional values a Fractions in Cell Format.

 

[ChrisHockley]

ooooh... i see what the issue is... to show 3/16 the cell is '3/16 because EXCEL won't show 3/16 as a fraction by itself... at least I don't know how. It converts it to 1/5?!?! And that's what's messing with this.

 

[DanteAmor]

varios 21oct2024.xlsm
	A	B	C
1	Ounces	g
2	3/16	5.669904625	Format cell as fraction as sixteenths
3	mar-16	1202870.266	here it is taking it as a date
Hoja2

Cell Formulas
Range	Formula
B2:B3	B2	=CONVERT(A2,"ozm","g")

 

[Skyybot]

ooooh... i see what the issue is... to show 3/16 the cell is '3/16 because EXCEL won't show 3/16 as a fraction by itself... at least I don't know how. It converts it to 1/5?!?! And that's what's messing with this.

Nice. You good then?

 

[DanteAmor]

This option: