Yah, a custom format will make it appear as explained with additional \"@\"
for print-out.

Reason i need it to physically highlight it with a double quote on both side
is to let it go along and I will pass these newdata for the next data user.

Although i can make concatenation with a double quote, yet the text values
along Col. A are copied from other source and i dont want to mess with these
data provided for my re-use.
Practically, I will just have to add a double quote on both side.
Regardless of how many quote exist therein.

It is a part of data review processing of <step-by-step subsequent data
transfers to users.

Now after verifying, I still dont know why the single quote is insisted by
orig source user to still remain there.

Meaning its MY ERR.. on initial post...
'16 should appear as "'16".
These double quotes will mean that the data passed thru me and the next user
will not use mydata if there are no double quotes with it..
Its like trademarking of each data processor. Others use to insert other
wildcard as trademark on their processed data.

Is this still possible ? A macro looks sleek and happy to learn with it.

--
regards

"JoeU2004" wrote:

"driller" wrote:
tied it but it doesnt appear in either side
A1='16 ------ there is a single quote on the left side of 16.

Joel's suggestion, as written, works only if 16 is a number. You
specifically said it is text -- namely '16 -- and you said that you the
double-quoted result to "remain as text", although your exact wording is
subject to interpretation.

Borrowing from Joel, the following should work: the custom format \"@\" .


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

"driller" wrote in message
...
tied it but it doesnt appear in either side
A1='16 ------ there is a single quote on the left side of 16.

"Joel" wrote:

You can use a custom format to get the double quotes

\"#\"



"driller" wrote:

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