# Reverse Numbers Formula

#### MrsFrankieH

##### Active Member
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:

Frankie

#### Attachments

• Reversal.png
18.7 KB · Views: 14

#### MrsFrankieH

##### Active Member
If you have the subscription version then it would be office 365 (which is newer than 2019). It will have everything that is in 2019 plus some new features as well.

The link contains a full guide on how to use XL2BB, there is not really anything that I can tell you which is not already explained there.
Thank you again Jason!!

I so appreciate you helping me with this!
I will give update (put correct version of subscription in my profile) and have a go at this first change I get (after I wake up lol).
Thanks again and I'm truly grateful!

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

##### Well-known Member
I don't have acumen in code. Do you know a formula that would reverse the numbers? I appreciate your expertise and effort.
Excel Formula:
``=IF( MID(A1, 2, 1)<>"",MID(A1, 2, 1),0)&LEFT(A1, 1)``

#### Yongle

##### Well-known Member
What does "stretched out the cell" mean?

#### MrsFrankieH

##### Active Member
Excel Formula:
``=IF( MID(A1, 2, 1)<>"",MID(A1, 2, 1),0)&LEFT(A1, 1)``

#### MrsFrankieH

##### Active Member

Hi Mohadin, I put the formula in G1 and ran into the same problem (stretched rows). I'm not sure what I'm doing wrong but as I told Jason, I must learn VBA I think if I'm having difficulty with the formula.
Thank you so much for your help!!

#### MrsFrankieH

##### Active Member
What does "stretched out the cell" mean?
Hello Yongle. I don't know the technical term but here's a screenshot of the problem.

#### Attachments

• strech.png
26.5 KB · Views: 6

#### Rick Rothstein

##### MrExcel MVP

Here is another formula that you can try...
Excel Formula:
``=MID(TEXT(A1,"00")&TEXT(A1,"00"),2,2)``

##### Well-known Member
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 ";"

#### Yongle

##### Well-known Member
Hello Yongle. I don't know the technical term but here's a screenshot of the problem.
Looks like user error
Your formula is not a formula - it is text

#### Rick Rothstein

##### MrExcel MVP
Here is another formula you can consider...
Excel Formula:
``=MID(A1&TEXT(A1,"00"),LEN(A1),2)``

Replies
12
Views
128
Replies
11
Views
216
Replies
11
Views
172
Replies
0
Views
84
Replies
1
Views
105