Upside down text

[excel on the run]

How can i invert the text of a cell??
Thanx Brian

 

[Scott T]

You can use a text box and then make the text box upside down and the text will be upside down.

You could also use word art and use the rotate options under format.

 

[JazzSP8]

I've never been able to do this - The last time I needed to do this I used a Text Book formatted to look like the rest of my text and flipped that upside down.

Interested to know if there is a better way though?

 

[PatOBrien198]

As far as I know, the cell formatting limits you to +-90 degrees. So not totally inverted.

You CAN invert a text box. You can have the text in the text box be from a cell.
The text box can be positioned over a cell and the properties should be "Move and size with cells".
Then, if you make the "Line Color" to be "No line" it will appear as a cell.... sort of.

 

[thisoldman]

This won't display correctly for many. These forums don't tell your browser to use Unicode.

For Firefox , go to View on the menu Alt+V > Text Encoding > Unicode.

<colgroup><col style="mso-width-source:userset;mso-width-alt:950;width:20pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1718;width:35pt" width="47"> <col style="mso-width-source:userset;mso-width-alt:621;width:13pt" width="17"> <col style="mso-width-source:userset;mso-width-alt:950;width:20pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1718;width:35pt" width="47"> </colgroup><tbody>
[TD="class: xl66, width: 26"]ɐ
[/TD]
[TD="class: xl67, width: 47, align: right"]592[/TD]
[TD="class: xl67, width: 17"] [/TD]
[TD="class: xl66, width: 26"]u[/TD]
[TD="class: xl67, width: 47, align: right"]117[/TD]

[TD="class: xl66"]q[/TD]
[TD="class: xl67, align: right"]113[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]o[/TD]
[TD="class: xl67, align: right"]111[/TD]

[TD="class: xl66"]ɔ[/TD]
[TD="class: xl67, align: right"]596[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]d[/TD]
[TD="class: xl67, align: right"]100[/TD]

[TD="class: xl66"]p[/TD]
[TD="class: xl67, align: right"]112[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]b[/TD]
[TD="class: xl67, align: right"]98[/TD]

[TD="class: xl66"]ǝ[/TD]
[TD="class: xl67, align: right"]477[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]ɹ[/TD]
[TD="class: xl67, align: right"]633[/TD]

[TD="class: xl66"]ɟ[/TD]
[TD="class: xl67, align: right"]607[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]s[/TD]
[TD="class: xl67, align: right"]115[/TD]

[TD="class: xl66"]ɓ[/TD]
[TD="class: xl67, align: right"]595[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]ʇ[/TD]
[TD="class: xl67, align: right"]647[/TD]

[TD="class: xl66"]ɥ[/TD]
[TD="class: xl67, align: right"]613[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]n[/TD]
[TD="class: xl67, align: right"]110[/TD]

[TD="class: xl66"]ᴉ[/TD]
[TD="class: xl67, align: right"]7433[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]ʌ[/TD]
[TD="class: xl67, align: right"]652[/TD]

[TD="class: xl66"]ɾ[/TD]
[TD="class: xl67, align: right"]638[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]ʍ[/TD]
[TD="class: xl67, align: right"]653
[/TD]

[TD="class: xl66"]ʞ[/TD]
[TD="class: xl67, align: right"]670[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]x[/TD]
[TD="class: xl67, align: right"]120[/TD]

[TD="class: xl66"]l[/TD]
[TD="class: xl67, align: right"]108[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]ʎ[/TD]
[TD="class: xl67, align: right"]654[/TD]

[TD="class: xl66"]ɯ[/TD]
[TD="class: xl67, align: right"]623[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]z[/TD]
[TD="class: xl67, align: right"]122[/TD]

</tbody>

<colgroup><col style="mso-width-source:userset;mso-width-alt:950;width:20pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1718;width:35pt" width="47"> <col style="mso-width-source:userset;mso-width-alt:621;width:13pt" width="17"> <col style="mso-width-source:userset;mso-width-alt:950;width:20pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1718;width:35pt" width="47"> </colgroup><tbody>
[TD="class: xl66, width: 26"]Ɐ[/TD]
[TD="class: xl67, width: 47, align: right"]11375[/TD]
[TD="class: xl67, width: 17"] [/TD]
[TD="class: xl66, width: 26"]N[/TD]
[TD="class: xl67, width: 47, align: right"]78[/TD]

[TD="class: xl66"]ᗺ[/TD]
[TD="class: xl67, align: right"]5626[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]O[/TD]
[TD="class: xl67, align: right"]79[/TD]

[TD="class: xl66"]Ɔ[/TD]
[TD="class: xl67, align: right"]390[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]Ԁ[/TD]
[TD="class: xl67, align: right"]1280[/TD]

[TD="class: xl66"]ᗡ[/TD]
[TD="class: xl67, align: right"]5601[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]Ό[/TD]
[TD="class: xl67, align: right"]908[/TD]

[TD="class: xl66"]Ǝ[/TD]
[TD="class: xl67, align: right"]398[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]ᴚ[/TD]
[TD="class: xl67, align: right"]7450[/TD]

[TD="class: xl66"]Ⅎ[/TD]
[TD="class: xl67, align: right"]8498[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]S[/TD]
[TD="class: xl67, align: right"]83[/TD]

[TD="class: xl66"]⅁[/TD]
[TD="class: xl67, align: right"]8513[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]⊥[/TD]
[TD="class: xl67, align: right"]8869[/TD]

[TD="class: xl66"]H[/TD]
[TD="class: xl67, align: right"]72[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]∩[/TD]
[TD="class: xl67, align: right"]8745[/TD]

[TD="class: xl66"]I[/TD]
[TD="class: xl67, align: right"]73[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]Λ[/TD]
[TD="class: xl67, align: right"]923[/TD]

[TD="class: xl66"]ſ[/TD]
[TD="class: xl67, align: right"]383[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]M[/TD]
[TD="class: xl67, align: right"]77[/TD]

[TD="class: xl66"]ꓘ[/TD]
[TD="class: xl67, align: right"]42200[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]X[/TD]
[TD="class: xl67, align: right"]88[/TD]

[TD="class: xl66"]⅂[/TD]
[TD="class: xl67, align: right"]8514[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]⅄[/TD]
[TD="class: xl67, align: right"]8516[/TD]

[TD="class: xl66"]W[/TD]
[TD="class: xl67, align: right"]87[/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl66"]Z[/TD]
[TD="class: xl67, align: right"]90[/TD]

</tbody>

<colgroup><col style="mso-width-source:userset;mso-width-alt:950;width:20pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1718;width:35pt" width="47"> <col style="mso-width-source:userset;mso-width-alt:621;width:13pt" width="17"> <col style="mso-width-source:userset;mso-width-alt:950;width:20pt" width="26"> <col style="mso-width-source:userset;mso-width-alt:1718;width:35pt" width="47"> </colgroup><tbody>
[TD="class: xl66, width: 26"]0[/TD]
[TD="class: xl67, width: 47, align: right"]48[/TD]
[TD="class: xl68, width: 17"] [/TD]
[TD="class: xl66, width: 26"]⅋[/TD]
[TD="class: xl67, width: 47, align: right"]8523[/TD]

[TD="class: xl66"]6[/TD]
[TD="class: xl67, align: right"]54[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"]‾[/TD]
[TD="class: xl67, align: right"]8254[/TD]

[TD="class: xl66"]8[/TD]
[TD="class: xl67, align: right"]56[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"]¿[/TD]
[TD="class: xl67, align: right"]191[/TD]

[TD="class: xl66"]ㄥ[/TD]
[TD="class: xl67, align: right"]12581[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"]¡[/TD]
[TD="class: xl67, align: right"]161[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl67, align: right"]57[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"]„[/TD]
[TD="class: xl67, align: right"]8222[/TD]

[TD="class: xl66"]5[/TD]
[TD="class: xl67, align: right"]53[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"],[/TD]
[TD="class: xl67, align: right"]44[/TD]

[TD="class: xl66"]߈[/TD]
[TD="class: xl67, align: right"]1992[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"]˙[/TD]
[TD="class: xl67, align: right"]729[/TD]

[TD="class: xl66"]Ɛ[/TD]
[TD="class: xl67, align: right"]400[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"]'[/TD]
[TD="class: xl67, align: right"]39[/TD]

[TD="class: xl66"]ᘔ[/TD]
[TD="class: xl67, align: right"]5652[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl66"]؛[/TD]
[TD="class: xl67, align: right"]1563[/TD]

[TD="class: xl66"]⇂[/TD]
[TD="class: xl67, align: right"]8642[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl67"] [/TD]
[TD="class: xl67"] [/TD]

</tbody>

The left hand side is the glyph. The right hand side is the Unicode decimal number. To display the glyph, use the UNICHAR function, =UNICHAR(8513) shows an inverted G.

Have fun.
uɐɯplosᴉɥʇ --

 

[thisoldman]

I looked into browser encoding and neither MS Edge nor Google Chrome will let you force the encoding to UTF-8 or some other encoding that allows Unicode. I can only get the page to display correctly in Firefox, and I have to manually set it.

And, among other features these forums don't specify UTF-8 as the encoding. Drat!

Here's a picture: