Joining text with a formula in cell

  • Thread starter Thread starter Mustard Head
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Joining text with a linked date 2
text & formual problem combined 5
Incorrect result for simple SUM formula 9
Rounding Effecting Sum 2
Access stripping decimal places in query 1
Equations and Text in same Cell 2
Decimal Place goes crazy when using the "&" Sign. 4
office 2003 Excel - SUM 3

Back
Top