Reverse Numbers Formula

MrsFrankieH

Active Member
Joined
Mar 25, 2011
Messages
268
Office Version
  1. 365
Platform
  1. Windows
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
 

Attachments

  • Reversal.png
    Reversal.png
    18.7 KB · Views: 14

MrsFrankieH

Active Member
Joined
Mar 25, 2011
Messages
268
Office Version
  1. 365
Platform
  1. Windows
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. :)
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

mohadin

Well-known Member
Joined
Mar 22, 2015
Messages
603
Office Version
  1. 2013
Platform
  1. Windows
Have you tried to replace Coma "," with semi-column ";"
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,400
Office Version
  1. 2010
Platform
  1. Windows
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

Well-known Member
Joined
Dec 30, 2008
Messages
10,970
Office Version
  1. 2019
Platform
  1. Windows

ADVERTISEMENT

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

Active Member
Joined
Mar 25, 2011
Messages
268
Office Version
  1. 365
Platform
  1. Windows
Here is another formula you can consider...
Excel Formula:
=MID(A1&TEXT(A1,"00"),LEN(A1),2)
Ah May be you mean
Excel Formula:
=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

Well-known Member
Joined
Mar 11, 2015
Messages
6,868
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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

Active Member
Joined
Mar 25, 2011
Messages
268
Office Version
  1. 365
Platform
  1. Windows
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

Active Member
Joined
Mar 25, 2011
Messages
268
Office Version
  1. 365
Platform
  1. Windows
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

Active Member
Joined
Mar 25, 2011
Messages
268
Office Version
  1. 365
Platform
  1. Windows
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!!
 

Watch MrExcel Video

Forum statistics

Threads
1,112,798
Messages
5,542,569
Members
410,560
Latest member
1ndependent
Top