Thread: text and number combined in a cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bearacade Bearacade is offline
external usenet poster
  
Posts: 1
Default text and number combined in a cell

=a1 & " " & Dollar(d1,0)

or if you are putting this in A1, ="The total as of March 1st was " &
Dollar(d1,0)

You don't want to use text because the comas won't show.


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=570918

Reply With QuoteReply With Quote