Tuberockin
New Member
- Joined
- Feb 19, 2002
- Messages
- 12
Hi everyone,
I hope someone can help me with this little query.
I have a number calculated in A3 that I have rounded to 0 decimal places. I want to refer to this number in cell A1 and adding text after it.
As an example in A1 =indirect(A3&"text")
How can I make the number from A3 rounded in A1? When I try the above it calls a number of a large number of decimal places.
Thanks for your help.
I hope someone can help me with this little query.
I have a number calculated in A3 that I have rounded to 0 decimal places. I want to refer to this number in cell A1 and adding text after it.
As an example in A1 =indirect(A3&"text")
How can I make the number from A3 rounded in A1? When I try the above it calls a number of a large number of decimal places.
Thanks for your help.