New Line Code for Cell Format

[C Brandt]

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]

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.

 

[Bernie Deitrick]

Craig,

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

HTH,
Bernie
MS Excel MVP