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

### 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)

#### MrsFrankieH

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

##### Well-known Member
Have you tried to replace Coma "," with semi-column ";"

#### Rick Rothstein

##### MrExcel MVP
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

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
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 ";"
I'm still getting errors.
I understand why using code is the best solution.

#### Yongle

##### Well-known Member

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
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
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
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!!

Replies
12
Views
127
Replies
11
Views
215
Replies
11
Views
170
Replies
0
Views
77
Replies
1
Views
104