Joining text with a linked date

  • 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 full
amount of decimals in the sum then the *. Might be something simple but
if so I cant see the wood for the tress.
 
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 formula in cell 2
Access stripping decimal places in query 1
Incorrect result for simple SUM formula 9
text & formual problem combined 5
How do you hide .00's in a worksheet & keep the ones that say 10.7 3
Decimal Place goes crazy when using the "&" Sign. 4
Joining text with a formula in cell 1
Why is Excel calculating a number? 2

Back
Top