In a helper column enter

=cellref & "."

Copy down then paste special as value.


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 10:21:01 -0700, Cazumel
wrote:


Hi

I have the following situation:
94101 How do i add a (.) ( Period at the end of each number in each Cell)
94101
94101
93001
93001