Thanks Dave,

Your solution works to convert the number to text, but when I copy down the
formula I still lose some formatting. Also, this extract that I am referring
to in my original question is availabe to in excess of 200 users within my
organization.

I still would like to no if there is a way for me to either fix Excel or the
download so that all users would need to do would be to open the file.