Thread: Retaining Formatting in 'joined' cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default Retaining Formatting in 'joined' cells
Hi,

You need to format the result of the ROUND function.

="$"&TEXT(ROUND(VALUE(D28),0),"#,##0")& "/" & VALUE(D27)

Cheers
Andy

On 15/02/2010 16:15, Dowitch wrote:
="$"&ROUND(VALUE(D28),0)& "/"& VALUE(D27)
Reply With QuoteReply With Quote