I'd like to be able to rotate the text entered in a cell by 180 degrees. It
appears that this can't be done in Excel anymore. Is there a workaround?

Thanks,
Barb Reinhardt

The maximum number is +/- 90 degrees

"Barb Reinhardt" wrote:

I'd like to be able to rotate the text entered in a cell by 180 degrees. It
appears that this can't be done in Excel anymore. Is there a workaround?

Thanks,
Barb Reinhardt

One alternative is to insert a Word Art object

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Teethless mama" wrote in message
...
The maximum number is +/- 90 degrees

"Barb Reinhardt" wrote:

I'd like to be able to rotate the text entered in a cell by 180 degrees.
It
appears that this can't be done in Excel anymore. Is there a
workaround?

Thanks,
Barb Reinhardt

Are you wanting it flipped upside down, or just backwards? If upside down,
Teethless mama is correct, you can't do that with a cell. You'd have to use a
text box/drawing. If you just want the info reveresed, you could use this UDF:

Function FlipIt(Old_Text As String) As String
For i = 1 To Len(Old_Text)
FlipIt = Mid(Old_Text, i, 1) & FlipIt
Next
End Function
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Barb Reinhardt" wrote:

I'd like to be able to rotate the text entered in a cell by 180 degrees. It
appears that this can't be done in Excel anymore. Is there a workaround?

Thanks,
Barb Reinhardt

Barb

appears that this can't be done in Excel anymore

180 degrees rotation could never be done in any version of Excel.

Let's see.............180 degrees rotation would turn the text right to left
and upside down.

I can get text to change from left to right to right to left but not upside
down.

Public Function RevStr(rng As Range)
RevStr = StrReverse(rng.text)
End Function

Otherwise you would have to take a picture of the cell and rotate.


Gord Dibben MS Excel MVP

On Wed, 19 Aug 2009 08:11:03 -0700, Barb Reinhardt
wrote:

I'd like to be able to rotate the text entered in a cell by 180 degrees. It
appears that this can't be done in Excel anymore. Is there a workaround?

Thanks,
Barb Reinhardt

You could put the text to rotate 180 degrees in an out of the way cell.

The edit|copy (xl2003 menus)
Select the cell where you want the inverted text to be.
Shift-edit|paste picture link
Then rotate this picture so that it's upside down.

Any changes you make to that out of the way cell will be reflected in the
picture link.

Barb Reinhardt wrote:

I'd like to be able to rotate the text entered in a cell by 180 degrees. It
appears that this can't be done in Excel anymore. Is there a workaround?

Thanks,
Barb Reinhardt

--

Dave Peterson