Numbers

[elgringo56]

I have a cell that has a number in it, it could be any number from 1 to 99,999,999. I have set up 8 cells, A1 thru H1. I would like to put the least significant digit in cell H1, second least significant digit in Cell G1 and so on back to the most significant digit, it it is a number that large, in Cell A1. Does anyone know how I can do this with forumulas instead of macros?

 

[PaddyD]

In which case, Juan's is the way to go...(it would be straightforward to alter the method I posted to you're revised situation).

One thing though - you said:

"I would like to put the least significant digit in cell H1, second least significant digit in Cell G1 and so on back to the most significant digit"

If a number has one digit, it has one most significant digit - surely it should be in A1, not H1??? As I said earlier:

"if you want significant digits, the single digit number 9's most significant digit is 9, as is 98,765,432. Your formula would match the number 9's 9 with 98,765,432's 2."

or am I missing something?

Paddy
This message was edited by PaddyD on 2002-08-27 19:08

 

[elgringo56]

You are right, paddy, a one digit number has both a least and a most significant digit that are the same. However in all other numbers the least significant is on the right and I needed that is cell H1. At any rate, it all works well and I thank you both. The only problem was, that after the formula, the "numbers" are no longer seen by excel as numbers, but as text. for my purposes, that was ok, I just had to change some of my formula by adding quote marks. What I am doing is, using english software, converting numbers to the verbal equivalent in spanish for writing checks. It seems there are few, if any spanish versions of accounting programs that can write checks here in Mexico because of the verbage used here for numbers.
This message was edited by elgringo56 on 2002-08-27 19:40

 

[PaddyD]

Re the 'text' numbers - just add a +0 to the formula to convert back to numbers:

=MID(TEXT($A3,"00000000"),COLUMN(A2),1)+0

Paddy

 

[elgringo56]

Thanks, Paddy, I will remember that.