Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

format cell to display text upside-down

Posted by Troy on January 27, 2002 1:49 PM
I would like to format a cell so it's value will be displayed upside-down. If I format the top cell of a sheet to be upside-down it can be read when placed in an employee in box with-out removing the sheet.
Hope you can help.
Thanks,
Troy

Re: format cell to display text upside-down

Posted by Ivan F Moala on January 27, 2002 2:55 PM

Hi Troy

Couple of options
1) Why not use Footers and input the cell data
into the footer
2) Use WordArt and Flip the wordart

HTH


Ivan


Re: format cell to display text upside-down

Posted by Ivan F Moala on January 28, 2002 10:55 AM
Thank you for your reply. The value of the data I would like displayed upside-down will change. With-in the spreadsheet I have about 40 different pages that will print out with different values. This printed sheet will then be wrapped around construction drawings and then put into storage bins in the side of a wall. Only the last 3" of the roll will stick out of the bin and I would like to label them for easy access. The cell I would like the text displayed upside-down is linked to another sheet. Don't know if the header would work, but will try. Thanks again.


Hi Ivan

Posted by jack in the UK on January 28, 2002 2:08 PM

hi Ivan --

Sorry to step in, not toe treading, but i have tried and tried the same for years, maybe like me Troy is doing some presentation or report so i had the silly idera od upside down text for me and would be super cool!

This is teh answer, a font custom ie USD or USD + backwards which would be true unside down mirror image, like we all played as kids.

My polt was VBA to turn ALL text USD or USD BtoF or select text in sell by hightlighting and them run macro.

BUT... im not very strong at complex VBA so i tried to design a font USD i failed....

So thats my take and i tell you what COOL if can be done..... I have bet that my mate will take me out all night dringing bottles of beer if i can prove him wrong

Word art is not quite as we like it.

Ivan ... Over to you.

Take care friend
Rdgs
Jack...


Re: Hi Ivan

Posted by Ivan F Moala on January 28, 2002 2:27 PM
Hi Jack
That's a great idea.....I'll have alook and see
if you get those bottles of beer ;-)


Cheers


Ivan hi Ivan -- Sorry to step in, not toe treading, but i have tried and tried the same for years, maybe like me Troy is doing some presentation or report so i had the silly idera od upside down text for me and would be super cool! This is teh answer, a font custom ie USD or USD + backwards which would be true unside down mirror image, like we all played as kids. My polt was VBA to turn ALL text USD or USD BtoF or select text in sell by hightlighting and them run macro. BUT... im not very strong at complex VBA so i tried to design a font USD i failed.... So thats my take and i tell you what COOL if can be done..... I have bet that my mate will take me out all night dringing bottles of beer if i can prove him wrong Word art is not quite as we like it. Ivan ... Over to you. Take care friend


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.