View Single Post
  #1   Report Post  
Nigel
 
Posts: n/a
Default Formatting range in concatanate

Hi,
I have a problem in a concatanating formula. my text is pretty simple, with
this, i have added a value from a cell. This is a percentage figure (25%).
Only, it looks like this 25.04568472367376574%. I have formatted the cell to
1 decimal point but can this be done for the concatanating formula?


Regards,

Nigel