Forum Discussion
Solved
Format numbers within a formula containing text and numbers
Hello, How do I format numbers within a formula containing text and numbers, to look exactly as they appear in cells J1 and J2 in the attached excel? For example I want the sentence below: F...
JennyHoA20181 Adjust your formula to this:
="Forecast: is currently tracking at "&TEXT(J1,"#,##0")&". A decline of "&TEXT(J2,"0%")&" vs RAD target"It will correctly display the number format, but as far as I know, it's not possible to set the font format (bold and red).
Great! Thank you! This helps a lot, I will do the Bold and colour manually in that case. Is it possible to add a + in the formula if the percentage / number is positive?
JennyHoA20181 Like this!
="Forecast: is currently tracking at "&TEXT(J1,"#,##0")&". A decline of "&TEXT(J2,"+0%;-0%")&" vs RAD target"
- Thank you very much!