How do I add (') at the beginning and end of a series of numbers?
 

I have a series of 6 digit number that I need to edit to be include (') at
the beginning and end and then place a (,) after each. Is there a quick way
to handle this rather than keying on every line, since there are over 400
lines? EX.
Befo 123456 After should appear: '123456',
I have tried to enter the (') in a cell and then concatenate, however the
(') does not appear in the cell

How do I add (') at the beginning and end of a series of numbers?
 

use the following helper formula.
=CONCATENATE("'",A1,"',")

to clarify, left parentheses, then a double quote, then a single quote, then
a double quote, then a comma, then A1, then a double quote, then a single
quote, then a comma and lastly a double quote followed by a right parentheses.

"Ann" wrote:

I have a series of 6 digit number that I need to edit to be include (') at
the beginning and end and then place a (,) after each. Is there a quick way
to handle this rather than keying on every line, since there are over 400
lines? EX.
Befo 123456 After should appear: '123456',
I have tried to enter the (') in a cell and then concatenate, however the
(') does not appear in the cell