View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
briancrosier briancrosier is offline
external usenet poster
 
Posts: 4
Default Line Break in Cell Number Format

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?