A report lists in 2 columns an account number and a sub-account number as
numeric fields.
I want to concantenate these fields. when I use "=CONCATENATE(B7,C7)" I get
a #VALUE! error message. If I place a ' infront of the numbers in B7 and C7
then it works fine. Is there any way to use the concantenate function
without inserting the ' infront of a few thousand fields? Changing the cell
format to text has not worked.
Thanks