hi
better example.
put 777 in a cell and but a single quote before it. it now left justifes.
numbers right justify by default.

FSt1

"FSt1" wrote:

hi
you're right. but put 777 in a cell then add a double quote to it. it right
justifies and becomes text. his whole post confused me. I re-read it several
times. and he seems to be asking for a single double quote.
the symbols ', ^ and " are use by xl (and lotus) to signify wheather text
is to be left justified , centered or right justified. but if you put a
single double quote in a cell with no text data, the double quote doesn't
show.(nor do the other symbols) if you do have text data, it right justifies.
provide you don't wipe out the data adding it. and if all you wanted to do is
right justify then why not just high light the date and click the right
justify icon. your way worked too.
you don't know how close i come to asking the same question you did. why?

Regards
FSt1

"Gord Dibben" wrote:

You can't add double quotes to right-justify. If you have Transition options
enabled it will be automatic.


Gord


On Wed, 10 Oct 2007 18:35:00 -0700, FSt1 wrote:

hi gord,
I was assuming he had data in the cell and wanted to right justify it all.
but i have never figured out how to do that yet.

Regards
FSt1

"Gord Dibben" wrote:

Could be I missed the point of OP's question<g


Gord

On Wed, 10 Oct 2007 17:30:02 -0700, Mike wrote:

VBA Can do it.
This code will work on Column A Cells A1 thru the last Used cell in Column A
I'm guessing you want to put "" around Values you already have in the cells.

Before running code
Cell A1 value = Test
after you run the code
Cell A1 = "Test"

Sub addDoubleQuotation()
lastcell = Cells(Rows.Count, "A").End(xlUp).Row
For i = 1 To lastcell
Range("A" & i).Value = """" & Range("A" & i).Value & """"
Next
End Sub

"crazyfisher" wrote:

Dear all,

just want to know is it possible to autometically put a double quotation
mark in the cell content within the same column? because there are 84 cells,
i don't want to do it manually...

thanks very much !