M
mcgrape
I am using a mix of text and a formula to draw a number from another sheet
i.e. ="The average mark for the presentation was " & data!B282
B282 is the calculated figure on a scond sheet.
However, althought the imported number shows on the original page as '1.3'
for example, it imports the number showing it to about 12 decimal places. Is
there any way I can reduce that to 1 or 2 decimal places?
Thanks
Alec
Thanks
i.e. ="The average mark for the presentation was " & data!B282
B282 is the calculated figure on a scond sheet.
However, althought the imported number shows on the original page as '1.3'
for example, it imports the number showing it to about 12 decimal places. Is
there any way I can reduce that to 1 or 2 decimal places?
Thanks
Alec
Thanks