Richmandudeus
New Member
Probably an extremely easy fix...
What is the formula to report back what is in another cell as text?
keep in mind we are not allowed to format initial cell as text which is why it needs to report onto a different cell
ex.
A1: 12.0200 (accounting format)
B1: 12.0200 (report back as text)
I've tried a couple things but keep loosing the 0's at the end.
Thanks in advance.
What is the formula to report back what is in another cell as text?
keep in mind we are not allowed to format initial cell as text which is why it needs to report onto a different cell
ex.
A1: 12.0200 (accounting format)
B1: 12.0200 (report back as text)
I've tried a couple things but keep loosing the 0's at the end.
Thanks in advance.