Thread: cell formatting with formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default cell formatting with formula
Use the formula:

=TEXT(H22,"000000000") & CHAR(10) & TEXT(J22,"000000000")

Then select the cell that contains the formula
Choose FormatCells
On the Alignment tab, add a check mark to Wrap Text, and click OK

fair_thumb wrote:
Hello members,

my formula in A1 is
=TEXT(H22,"000000000")
&TEXT(J22,"000000000")

How can I force a *display* in A1 *to be* in two lines <one for each of my
*text sub-formula*

thanks in advance for any suggestions.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote