.0394 to display as 1mm

[STU22]

What do I need to enter to get .0394 to display as 1MM?

[FDibbins]

assuming that value is inches, try this...

=CONVERT(A1,"in","mm")

[TMS]

=ROUND(0.0394*2.54,2) = 1.0000


Regards, TMS

[STU22]

I should have provided more info

I have a cell with a drop down list. The list contains .0394,.0625,.1181

I have other cells with formulas based off the numbers listed above. When I click the drop down arrow and select .0394 I want it to show as 1MM, .0625 as 1/16, .1181 as 3MM.

[FDibbins]

what is the logic for that? why is 1 converting to fractions, and the others converting to (what looks like) milemeters?

[STU22]

I use different thickness of edgebanding. The .0625 could be 1.5MM Its just a comfort thing I use fractions and millimeters to build cabinets.

[FDibbins]

to the best of my knowledge, a cell cannot have 2 different formats like that. when you you have other formulas based off that drop-down, i assume they use 1, and not 1mm? if so, then what difference does it really make is the dropdown is always showing mm, and not fractions?

[shg]

If the choices are in a data validation list, why not just list them as you want them to appear?

[STU22]

Ok Thank You