going to format cells, number and changing to zero decimals doesn't workHow do I get non decimal figure in a CONCATENATE Excel cell?
CONCATENATE gives you a result that is considered text, so working with the number format wouldn't apply. However, if you do a copy/paste-values (you'll find it until Paste Special), and THEN change your answers to a number, then you'll be able to change the numbers to whatever Format you want.
If that doesn't help, giving a little more detail in your question would be helpful to the next person who asks. For example, what is the content of the cells being concatenated? and how do you want the answer to look? Just an idea.
Good luck.
Subscribe to:
Post Comments
(Atom)
No comments:
Post a Comment