So whilst the answer may be complicated, the problem is pretty simple...
I have a cell (A1) with a value, such as -2%.
The cell is formatted and will show underlined, red and bold.
I then have another cell with this formula. ="The latest week result is "&A1
but my result shows as...
The latest week result is -1.989877434%
Is there anyway to format that section to make sure its also red, bold, underlined and decimal places?
I have a cell (A1) with a value, such as -2%.
The cell is formatted and will show underlined, red and bold.
I then have another cell with this formula. ="The latest week result is "&A1
but my result shows as...
The latest week result is -1.989877434%
Is there anyway to format that section to make sure its also red, bold, underlined and decimal places?