Yes.

The original data will not be retained using that method.

See next post about saving as a *.txt file without adding any quote marks in
cells.


Gord

On Wed, 10 Oct 2007 21:06:02 -0700, crazyfisher
wrote:

the strange thing about this way is that all the value is reset to the active
cell one...
do I do sth wrong about that?

"Gord Dibben" wrote:

In namebox type A1:A84 and hit Enter key.

Type " in active cell and hit CTRL + Enter together

Just curious, but why would you want to do this?


Gord Dibben MS Excel MVP

On Wed, 10 Oct 2007 17:02:03 -0700, 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 !