Try instead of concatenate using:

Text(A8,"#")