"driller" wrote:
A1 = '16 -----as seen in formula bar with single left quote
I want to change this into "16"

I am not sure what you are asking for.

Do you know that you could enter "16" (with quotes) directly intead of '16?

Or are you asking: how do you convert a cell that has 16 as text (or
number) into a cell so the result is "16" (with quotes)?

For the latter, one way is to enter the following formula into another cell:

="""" & A1 & """"

Note that """" is 4 double-quotes in a row.

If you would like to overwrite A1 with that result, you can copy the cell
with the formula, then paste-special-value into A1.

If you have too many of these to do manually, you would create a macro. Do
you need help with that?


------ original message -----

"driller" wrote in message
...
Hello,

I tried to assure my numbers <in text to visually remain as text as it
is
by placing double quotes on the left & right side of each number - for
printout.

currently all the numebrs have a single quote " ' " on the left side of
each
numbers in Col A.

now i like to make it appear having a double quote on both left & right
side
of each column of numbers.

e.g. as it appears here below...
A1 = '16 -----as seen in formula bar with single left quote
I want to change this into "16" so the printed numbers appears with a
double-quote.

Any sleek solution = +appreciated.

--
regards