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