I am trying to convert existing data from text to number format. the cells contain numbers and text ((123.100grams). The text is always different as is the number of decimal places that need to be retained. Is there a way to pull the number of entered decimal places (i.e. 123.100 = 3) from this string? the Val function will return 123.1 but I loose the displayed decimals if I rewrite the cell Val after changing the format to number. I think I can calculate it by finding the position of the decimal, then finding the position of the last number... not sure how to find the last number though.
Cheers!
Cheers!