using the correct divisor

Lino · May 11th, 2002, 02:37 PM

Hello,

I have numerical data in column A and that data can vary in terms of number of digits.

Sometimes it can be 100, 1000, 10000, 100000

I have written a macro that loops through the rows in column A and divides the values by 10000. I initially wrote it this way because I thought the data was always a five digit number and I wanted my value to be no greater than a two digit number.

Is there a way that in my loop I can ask it to look for the value first and then decide what value divisor to use?

Thanks,

Lino

Aladin Akyurek · May 11th, 2002, 03:13 PM

If you can incorporate in your macro, you could use:

=A1/(10^LEN(A1))

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 11th, 2002, 02:37 PM	#1
Lino Board Regular Join Date: Feb 2002 Posts: 429	Hello, I have numerical data in column A and that data can vary in terms of number of digits. Sometimes it can be 100, 1000, 10000, 100000 I have written a macro that loops through the rows in column A and divides the values by 10000. I initially wrote it this way because I thought the data was always a five digit number and I wanted my value to be no greater than a two digit number. Is there a way that in my loop I can ask it to look for the value first and then decide what value divisor to use? Thanks, Lino

May 11th, 2002, 03:13 PM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	If you can incorporate in your macro, you could use: =A1/(10^LEN(A1))