Need Help Please with Excel Formula

[Lindee]

I am new to Excel and I'm trying to write a formula that will change the value of a set of numbers to a different value. i.e. 116 ~161~ 161 i.e. 225~ 552~525~ 520 for numbers 1 thru 0.
Would some kind soul Help me. I have started writing with the Subsitute function however I'm not advanced enough to go beyond the 1st 2 conversions.
Thanks in Advance.
Lindee

 

[Dryver14]

if that doesn't work delete the formula and type it in, do not paste

 

[Marcelo Branco]

I followed your instructions word for word and still the same problem.

My last attempt.
Go to:
File> Options> Advanced> Display options for this worksheet
and verify if this is checked
Show formulas in cells instead of their calculated results.
If so, uncheked it.

By the way, I think you should seek help from someone close to you who can better assess what is happening.
I do not know how to help you more. Hope someone can do it.

M.

 

[Rick Rothstein]

I hope you are not trying to guess the winning numbers of a lottery! That is usually an exercise in futility!

I think Joe has a typo here... he misspelled the word "completely" as "usually".

 

[Dryver14]

just a thought but aside from what you are looking for try typing this in any cell

=RANDBETWEEN(100,999)

this will generate a random 3 digit number just press the F9 Key to get a new number

 

[Lindee]

My last attempt.
Go to:
File> Options> Advanced> Display options for this worksheet
and verify if this is checked
Show formulas in cells instead of their calculated results.
If so, uncheked it.

By the way, I think you should seek help from someone close to you who can better assess what is happening.
I do not know how to help you more. Hope someone can do it.

M.

Yes that box was checked on the worksheet I installed on. I have unchecked the box and now I'm getting the result of "True or False" for (=ISNUMBERA2). Now where do I place the original formula you gave me, in each cell? Thank you Marcelo.

 

[Lindee]

Thank you Dryver14. I will try that also. I am looking for a specific formula for numbers that change to Palindrome numbers. I just recently found out that is the descriptive name for these numbers, ie. 161 changes to 616. My God this is now 7th grade Math.!!!!!!!!!! I had no CLUE~less.

 

[Lindee]

Yes that box was checked on the worksheet I installed on. I have unchecked the box and now I'm getting the result of "True or False" for (=ISNUMBERA2). Now where do I place the original formula you gave me, in each cell? Thank you Marcelo.

Here's a copy of the formula typed in the cell, word for word. I hit enter and the formula stays in the cell. Do I have to hit ALT, ?? OR something?.

TRUE	A	B	TRUE
1	Original	Converted
2	161	=SUMPRODUCT(MOD(MID(A2,{1;2;3},1)+5,10)*{100;10;1})
3	787	232
4	234	789
5	278	723	TRUE
6	109	654

<tbody>
</tbody>

this is all on the same sheet. It doesn't seem to recognize the pivot table cells. It's trying to read the Column and rows instead. I'm sorry you are frustrated, I would have never known to look for the Display setting .

 

[Marcelo Branco]

Check again if B2 is not formatted as Text.
See post 28

M.

 

[Lindee]

No, it's not, formatted as numbers.

 

[Marcelo Branco]

I do not know how to help you more.

M.