upside text in cells...

[sadams1]

I've looked around but haven't found a good answer to whether or not it's possible to turn text upside in a cell...not using "WordArt". Can any of you Excel wizards cook up code to do so?

 

[Oeldere]

rightclick on a cell

choose cellformat => second tab.

there are options to change the text.

 

[hiker95]

sadams1,

whether or not it's possible to turn text upside in a cell

1. What is the text?

2. Describe in detail what the results upside should look like?

 

[hiker95]

sadams1,

Now I understand.

Taking Oeldere's instructions a bit further:

right click on the cell
choose Format Cells...
click on the Alighment tab
on the right in the Orientation area
click on the red text pointer
and, rotate it up, or, down
and, click on the OK button

 

[sadams1]

I'd like to rotate 1 letter in a cell (it's the only character in the cell) 180 degrees. Excel only allows for 90 degrees in "formatting".

 

[hiker95]

sadams1,

I'd like to rotate 1 letter in a cell (it's the only character in the cell) 180 degrees.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[FormR]

Go to this site:

Upside Down Text | Flip Text, Type Upside Down, or Backwards Text

Enter your character and copy and resultant text to Excel.

 

[hiker95]

FormR,

It does seem to work in Excel.

Interesting, but, when I use MrExcl HTMLMaker, we get this?

Excel 2007
	A
1	?ormR
Sheet1

 

[FormR]

I suspect the HTML maker can't handle unicode characters..

You can get the HTML from the site though:

ɹɯɹoℲ

 

[DeezNuts]

This could be a way outside the box thought but what if you downloaded an upside font which has the characters upside down also ,and then format those cells with that font would that work?