Reverse Numbers Formula

[MrsFrankieH]

Hello Everyone!

My computer is Asus
My Operating system is Windows 10.

Can someone please help me with a formula that I can drag down (or up) to reverse numbers in a cells?
The range is 01 to 99.

Here is a sample:

Thank you in advance for your help and expertise.

Frankie

 

[MrsFrankieH]

Here is another formula that you can try...

Hello Rick!! I remember you, how are you?
I tried the formula and am experiencing the same problem. I don't know the technical term for it but I'm still experiencing distorted cells when I copy and paste the formula. I make sure there aren't any spaces after I've copied and pasted and I've used new spreadsheets just in case the problem is a broken cell.

Thank you so much for your help, I truly appreciate it.

 

[MrsFrankieH]

Looks like user error
Your formula is not a formula - it is text

Hello Yongle. Do you mean the solution may be turning the text into number?

 

[mohadin]

Have you tried to replace Coma "," with semi-column ";"

 

[Rick Rothstein]

What symbol do you use to separate arguments in a formula... a comma or a semi-colon? In other words, to sum cells A1 and C1, would you write this...

=SUM(A1,C1)

or this...

=SUM(A1;C1)

 

[jasonb75]

Either the cell is formatted as text or there is something in front of the = sign at the start of the formula.

If the formula needed to be semicolon delimited instead of comma delimited then it wouldn't appear as text, excel would prevent it from being entered and display a 'There is a problem with this formula' pop up message.

 

[MrsFrankieH]

Here is another formula you can consider...

=MID(A1&TEXT(A1,"00"),LEN(A1),2)

Ah May be you mean

=IF(A1<>"",IF( MID(A1, 2, 1)<>"",MID(A1, 2, 1),0)&LEFT(A1, 1),"")

You might replace each "," with ";"

Hello Mohadin!
I'm still getting errors.
I understand why using code is the best solution.

 

[Yongle]

Hello Yongle. Do you mean the solution may be turning the text into number?

No - you made an error in entering the formula
The solution works if entered correctly

 

[MrsFrankieH]

What symbol do you use to separate arguments in a formula... a comma or a semi-colon? In other words, to sum cells A1 and C1, would you write this...

=SUM(A1,C1)

or this...

=SUM(A1;C1)

Hi Rick,
I used a comma.
I appreciate you and the others for not giving up on me.

 

[MrsFrankieH]

No - you made an error in entering the formula
The solution works if enteraned correctly

Hi Yongle.
I copied and pasted the formulas, making sure to take out any spaces.

I'll keep trying.

Thanking for hanging in there with me.

You guys are awesome!!

 

[MrsFrankieH]

Either the cell is formatted as text or there is something in front of the = sign at the start of the formula.

If the formula needed to be semicolon delimited instead of comma delimited then it wouldn't appear as text, excel would prevent it from being entered and display a 'There is a problem with this formula' pop up message.

Hi Jason!
I changed it from text to numbers, no decimals. I'll try the formulas again! Thank you so much, I have a good feeling about this!!