On 2002-03-24 15:07, StevenData wrote:

Greetings,

I am trying to solve a simple problem using excel. I would like excel to convert the following numbers, 2.0, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9, 2.10, 2.11 (in feet) into 2.0, 2.08, 2.17, 2.25, 2.33, 2.4, 2.5,2.6, 2.66,2.75,2.83,2.9, respectively. How do you think I should go about solving this problem. Can it be done with Macros with the least effort? I cannot use formulas or functions to do it since I will be dealing with multiple IF Then statements. I appreciate your help. Thank you.

Sincerely,

Steve

## Like this thread? Share it with others