Hi, in excel when you combine text and a cell value, the output is several decimals. How do I trim this back?
If A1 has the value 256.63
using this formula
="This is the text "& A1
Result
This is the text 256.6333333333333333333
I need to just have
This is the text 256
If A1 has the value 256.63
using this formula
="This is the text "& A1
Result
This is the text 256.6333333333333333333
I need to just have
This is the text 256