MrExcel Consulting
Your One Stop for Excel Tips & Solutions

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

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

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.

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

Hi 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
Rdgs
Jack...

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

Re: Hi Ivan

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