Formula

C

Cazumel

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
 
G

Gord Dibben

In a helper column enter

=cellref & "."

Copy down then paste special as value.


Gord Dibben MS Excel MVP
 
C

Cazumel

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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to figure out Annual Rents 2
Time / Each Second Bewtween 9:30 AM and 4:15 PM 3
Getting a formula to reflect added columns 10
Newbie Help - IF Yes No Function 0
Excel - Wich Function should I use? 1
How can the font and size of (all) citation numbers be altered? 1
Space at end of multi page list to accommodate new entries 1
Cell data entering slow! 0

Top