Hi Guys:

Any idea on how I can force a "line feed" with a custom cell format?
I have a short cell that I would like to format as follows:

Last Download
2:37 PM
June 12, 2007

Word wrap doesn't seem to work and I looked at custom format, but the "alt
Return" that I use, when simply hand loading cells, does not work.

Any help will be appreciated,
Thanks,
Craig

Are you typing the date and time in (not the "last download" text)?

If yes, then you can use a custom format of:

"Last Download"$h:mm AM/PM$mmmm dd, yyyy

But don't type those $ signs. Type ctrl-j instead (both times!).

Then Format|cells|alignment tab
Check Shrink to fit (first!)
check wrap text (second)

And then resize your columnwidth and rowheight.

You'll find that you'll have to adjust that rowheight and columnwidth manually.



C Brandt wrote:

Hi Guys:

Any idea on how I can force a "line feed" with a custom cell format?
I have a short cell that I would like to format as follows:

Last Download
2:37 PM
June 12, 2007

Word wrap doesn't seem to work and I looked at custom format, but the "alt
Return" that I use, when simply hand loading cells, does not work.

Any help will be appreciated,
Thanks,
Craig

--

Dave Peterson

Craig,

Just set the cell to "Wrap Text" - on the "Alignment" tab of the format cell dialog.

HTH,
Bernie
MS Excel MVP


"C Brandt" wrote in message ...
Hi Guys:

Any idea on how I can force a "line feed" with a custom cell format?
I have a short cell that I would like to format as follows:

Last Download
2:37 PM
June 12, 2007

Word wrap doesn't seem to work and I looked at custom format, but the "alt
Return" that I use, when simply hand loading cells, does not work.

Any help will be appreciated,
Thanks,
Craig