View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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