View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Concatenate formula or &

If you're using the code I gave you , just format the cell with the
calculation as bold and red.

In article ,
Sam wrote:

This solved my old problem. my new problem is when I concatenate in one cell
the data lose their format. i want the final result to be 2 devided by 3 is
66.66% percent but i want 66.66% to be bold and red! do you know the solution
to this answer.