Custom Format

[Guest]

Hello,

I am using the custom format to enter a specific text value for a cell such
as "Title". This way I can enter a number value in the cell formula bar, but
have word "Title" appear in the cell. Is there a way to wrap the text that is
appearing in the cell or possibly create a break so the next word falls on
the next row of the cell?

Thanks,

 

[Guest]

Format > Cells... > Number > Custom

"hello"General

but between the

"hello"

and the

General

you must type CNTRL-j and format the cell for wrap on