# 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

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

#### jasonb75

##### Well-known Member
My computer is Asus
My Operating system is Windows 10.
We just need to know which version of Excel you're using (please update your profile so we don't have to ask or assume every time). Computer make and windows version should not make any difference.

It would also be helpful if you post your examples using XL2BB instead of screen captures (see link in my signature at the bottom of this post).
Book1
ABCDEFGHIJK
1671428596070418295
223455358623254358526
Sheet1
Cell Formulas
RangeFormula
G1:K2G1=--CONCAT(MID(TEXT(A1,"00"),{2,1},1))

#### etaf

##### Well-known Member
Various solutions including VBA to reverse numbers in a cell of any length number in the cell

#### Yongle

##### Well-known Member

=VALUE(RIGHT(A1,1)&LEFT(TEXT(A1,"00"),1))

##### Well-known Member

Or
VBA Code:
``````Function rever(TargetCell As Range) As Double
rever = IIf(Mid(TargetCell, 2, 1) <> "", Mid(TargetCell, 2, 1), 0) & Left(TargetCell, 1)
End Function``````

Excel Formula:
``=rever(A1)``

#### MrsFrankieH

##### Active Member
We just need to know which version of Excel you're using (please update your profile so we don't have to ask or assume every time). Computer make and windows version should not make any difference.

It would also be helpful if you post your examples using XL2BB instead of screen captures (see link in my signature at the bottom of this post).
Book1
ABCDEFGHIJK
1671428596070418295
223455358623254358526
Sheet1
Cell Formulas
RangeFormula
G1:K2G1=--CONCAT(MID(TEXT(A1,"00"),{2,1},1))
Hi Jason!
Some else asked me to do that same thing and I had no success (I'm not the most technical person in the world). Thank you so much Jason!!
Could you tell me where I would put the XL2BB ?

Thanks again!!

Frankie

#### MrsFrankieH

##### Active Member

Various solutions including VBA to reverse numbers in a cell of any length number in the cell

Various solutions including VBA to reverse numbers in a cell of any length number in the cell
Hello
We just need to know which version of Excel you're using (please update your profile so we don't have to ask or assume every time). Computer make and windows version should not make any difference.

It would also be helpful if you post your examples using XL2BB instead of screen captures (see link in my signature at the bottom of this post).
Book1
ABCDEFGHIJK
1671428596070418295
223455358623254358526
Sheet1
Cell Formulas
RangeFormula
G1:K2G1=--CONCAT(MID(TEXT(A1,"00"),{2,1},1))
I've updated my profile Jason! Thank you for the tip. Unfortunately I haven't explored writing script yet, just formulas but this gives me something to work on!!

Thank you so much, I truly appreciate your help and I look forward to exploring VBA!

#### jasonb75

##### Well-known 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.

#### MrsFrankieH

##### Active Member
Or
VBA Code:
``````Function rever(TargetCell As Range) As Double
rever = IIf(Mid(TargetCell, 2, 1) <> "", Mid(TargetCell, 2, 1), 0) & Left(TargetCell, 1)
End Function``````

Excel Formula:
``=rever(A1)``
Hello
Or
VBA Code:
``````Function rever(TargetCell As Range) As Double
rever = IIf(Mid(TargetCell, 2, 1) <> "", Mid(TargetCell, 2, 1), 0) & Left(TargetCell, 1)
End Function``````

Excel Formula:
``=rever(A1)``
I don't have acumen in code. Do you know a formula that would reverse the numbers? I appreciate your expertise and effort.

Thank you so much!!

#### MrsFrankieH

##### Active Member

=VALUE(RIGHT(A1,1)&LEFT(TEXT(A1,"00"),1))
Hi Yongle! Thank you so much!

Thank you again.

Replies
12
Views
130
Replies
11
Views
217
Replies
11
Views
175
Replies
0
Views
90
Replies
1
Views
109