Hmm! I hadn't tried shrinking the width... that's weird.

--
Rick (MVP - Excel)


"Dave Peterson" wrote in message
...
Just to add to Rick and Sean's reply...

Format|cells
On the Number tab
Custom category
"Lump Sum"(ctrl-j)$#,##0.00

Then on the Alignment tab
Uncheck Wrap text (temporarily)
Check Shrink to fit
Check Wrap text

You will have to adjust the rowheight manually.

If you don't have shrink to fit checked, you'll see #### if you shrink the
columnwidth--even when it looks like there's plenty of room for the
wrapped text
to show up.

briancrosier wrote:

I would like to format a number so that it reads as follows:

Lump Sum
$5,000.00

I know that using custom formatting I can add the text, but I would like
to
show the result in two lines. Is there a way to add a line break in
custom
formatting?

--

Dave Peterson