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?.

<tbody>
[TD="class: xl73, align: center"]TRUE[/TD]
[TD="class: xl76, width: 157"]A[/TD]
[TD="class: xl69, width: 362"]B[/TD]
[TD="class: xl72, width: 195, align: center"]TRUE[/TD]

[TD="class: xl69, width: 212"]1[/TD]
[TD="class: xl77, width: 157"]Original[/TD]
[TD="class: xl70, width: 362"]Converted[/TD]
[TD="class: xl66"][/TD]

[TD="class: xl69, width: 212"]2[/TD]
[TD="class: xl65, align: right"]161[/TD]
[TD="class: xl71, colspan: 2"]=SUMPRODUCT(MOD(MID(A2,{1;2;3},1)+5,10)*{100;10;1})[/TD]

[TD="class: xl69, width: 212"]3[/TD]
[TD="class: xl78, width: 157"]787[/TD]
[TD="class: xl75, width: 362"]232[/TD]
[TD="class: xl73, width: 195"][/TD]

[TD="class: xl69, width: 212"]4[/TD]
[TD="class: xl78, width: 157"]234[/TD]
[TD="class: xl75, width: 362"]789[/TD]
[TD="class: xl66"][/TD]

[TD="class: xl69, width: 212"]5[/TD]
[TD="class: xl78, width: 157"]278[/TD]
[TD="class: xl75, width: 362"]723[/TD]
[TD="class: xl74, align: center"]TRUE[/TD]

[TD="class: xl69, width: 212"]6[/TD]
[TD="class: xl78, width: 157"]109[/TD]
[TD="class: xl75, width: 362"]654[/TD]
[TD="class: xl66"][/TD]

</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.