Custom format question

[Youdaman]

I am trying to add a period (".") to the end of all values in the A column. I know how to do this if all the values were either numbers or text, but there will be a mix of numbers and text. For example, one value may be the number 6, while the next value may be "6A". Any ideas? Thanks!

[DonkeyOte]

Assuming numbers always positive then along the lines of: #.;;;@"."

[tigertiger]

try this formula:
=A1&"."

[Youdaman]

Assuming numbers always positive then along the lines of: #.;;;@"."

Thanks! That worked perfectly. I had already tried #.;@".", but didn't know to add the 2 extra semicolons.

[DonkeyOte]

Yes, in general: Positive;Negative;Zero;Text