View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Flip Letters and Numbers

Dave,
No joy. Remains "correct" way around.
You using Excel more recent than Office 2000 ?


NickHK

"Dave Peterson" wrote in message
...
Try doing it through the handles on the picture--not through the menu.



NickHK wrote:

Bob,
With XL2K, I can't get that to work.
Vector objects will flip, either manually or with the Flip menu, but I

am
guessing that because this is a Picture (a raster object), flipping is

not
possible. Indeed the menu option is greyed out.

Mark,
Short of using a graphics program, I suppose you could use the various
graphics APIs to do it in memory.

NickHK

"Bob Umlas" wrote in message
...
Select the cell containing the text, hold the shift key down and use
Edit/Copy Picture.
Click elsewhere, and stil hold the shift key and use Edit/Paste

Picture.
Now
select one of the white circle handles on the left and drag to the

right.
ANd you're done!
Bob Umlas
Excel MVP

"Qaspec" wrote in message
...
I'd like to flip the letters and numbers in a cell or range of

cells. I
am
going for the same effect as the front of an ambulance. The letters

and
numbers are inverted on the front of the vehicle but can be read

easily
through a rearview mirror. Yes,..there is a business need for this!

Mark



--

Dave Peterson