Adding Text

[OfficeWorker]

I currently have a column that has 5 digits but need to add the letter T before the digits in the same column. I have tried to create a new column and entered the formula =(T)&A but it doesn't seem to work. I checked on the column format and tried General and also Custom A00000 but neither work. I need help! Thanks.

 

[Jonmo1]

Welcome to the board..

I think it would be

="T"&A1

 

[OfficeWorker]

Thanks so much for the prompt reply. I had been trying that and it wasn't working. I finally figured it out by fluke.
=TEXT("T","T00000")&A1
Hope this will help others