Thread: Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cazumel Cazumel is offline
external usenet poster
 
Posts: 23
Default Formula

Thank you so much
Have a nice day

"Gord Dibben" wrote:

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