Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to change metric measurements
Hi
i requre a little bit of guidance and help to right a simple function I have a value in milimeters which i want to pass to a function followed by a string or value to show that i want the result converting in to a) meters & cm - lets call it m b) cms & mm - lets call it cm c) mm - lets call it mm even though i passing the mm's to the function as a number i wish it to display it as a string thus 1234,m i wish to return as 1 m 23.4 cm or 1234,cm will return 123 cm 4 mms or 123.4 cms or 1234 mm will return 1234 mms I know this should be easy but i just cant seem how i should structure my login.. was trying to use mod and fix .. i cant see why i can get my head round it.. as i done something similar for inches and passing the factor of the inches .... ie 1/8th 1/16th etc to it.. to display feet inches and denominator... please help.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can function in one cell change value or function in another cell? | Excel Worksheet Functions | |||
What is the Formula to Convert Imperial to Metric Measurements | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Custom Function not being auto calculated when cells change..help? | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions |