Joining text with a formula in cell

M

Mustard Head

Does anybody know how to change the decimal places after using &"*"
Even if the cell is set to 2 decimal places it will show the ful
amount of decimals in the sum then the *. Might be something simple bu
if so I cant see the wood for the tress
 
J

JulieD

Hi

i saw your last post 30mins or so ago and didn't really understand that one
either ...
what do you have in the cell (formula & value) and what do you want to see?

the ROUND function is used to control the number of decimal places returned
by a formula so maybe
=ROUND(your_formula,2) might work.

Cheers
JulieD
 
Top