Formula

Cazumel · Jul 10, 2008

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

Gord Dibben · Jul 10, 2008

In a helper column enter

=cellref & "."

Copy down then paste special as value.

Gord Dibben MS Excel MVP

Cazumel · Jul 10, 2008

Thank you so much
Have a nice day

Gord Dibben said:
In a helper column enter

=cellref & "."

Copy down then paste special as value.

Gord Dibben MS Excel MVP