adding an alpha list to a sum cell

[sallymccowan]

Hi I am trying to add an alpha list to a calulated sum. The example i
00.00632 and I need to add an a to Z at the end. Not sure this i
possible

 

[Frank Kabel]

Hi
=SUM(A1:A100) & "Z"

 

[Gord Dibben]

Custom Format

#,##00.00000"Z"

Gord Dibben Excel MVP