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

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

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

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

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

Yep--xl2003.

But I don't recall a difference with earlier versions.

Maybe someone with xl2k can chime in and tell me that I'm all wet.

NickHK wrote:

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

--

Dave Peterson

Using Excel 2003, it worked using either the mouse or the menu (flip
horizontal) using picture or bitmap.

--
Regards,
Tom Ogilvy

"NickHK" wrote in message
...
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

From http://office.microsoft.com/en-us/as...371261033.aspx

How can I flip a font or make it a mirror font?
Answer
Well, this is tricky. You can't take a font itself and flip it or mirror it.
Fonts are fonts; they're just how they are and you can't change them.

You also can't just take a character, word, or paragraph in Word, for
example, and flip it or mirror it either. The only way you can flip text is
if it's in a drawing object, such as a text box, a shape, WordArt, or in a
table cell. The only way to mirror text is if it's in an AutoShape, picture,
WordArt, or piece of clip art.
To flip or change the orientation of text in an object
Click the drawing object or table cell that contains the text you want to
change.
On the Format menu, click Text Direction.
Click the orientation you want.
To mirror text
Click the AutoShape, picture, WordArt, or clip art you want to mirror.
On the Drawing toolbar, click Draw, point to Rotate or Flip, and then click
Flip Horizontal or Flip Vertical.

========
My own comments:
There may be some downloadable "special effects" fonts that might give a
mirrored font, but I am not aware of any - try an internet search on "mirror
font"

--
- K Dales


"Qaspec" wrote:

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