View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Line Break in Cell Number Format

use ALTand 0010 from your number pad, not the top row of your keyboard, to
enter a line break in format cells.

"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?