New Line Code for Cell Format
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
|