ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula (https://www.excelbanter.com/excel-worksheet-functions/194428-formula.html)

Cazumel

Formula

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

Formula

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

Cazumel

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

All times are GMT +1. The time now is 07:49 PM.