View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
driller driller is offline
external usenet poster
 
Posts: 740
Default sustain numbers with double quotes

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