sustain numbers with double quotes

  • Thread starter Thread starter driller
  • Start date Start date
D

driller

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.
 
driller said:
A1 = '16 ----->as seen in formula bar with single left quote
I want to change this into "16"
Click to expand...

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 -----
 
tied it but it doesnt appear in either side
A1='16 ------> there is a single quote on the left side of 16.
 
driller said:
tied it but it doesnt appear in either side
A1='16 ------> there is a single quote on the left side of 16.
Click to expand...

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 -----
 
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.
 
Back
Top