software

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

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

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.

quot;Annquot; wrote:

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