Another method to change the time values to text.

In B1 enter =TEXT(A1,"h:mm AM/PM")

Copy and paste specialvaluesokesc

Delete column A


Gord



On Wed, 10 Oct 2007 21:48:00 -0700, crazyfisher
wrote:

Yes, that is not what i want to see....
I was using the code by Mike, and it is working fine for general cells, but
what if it is cells with formats? such as time value? such as 9 am,. if I use
the code, it will change 9am to "0.375", I understand I should change the
code to accomdate this , but I am not sure how.
:

"Gord Dibben" wrote:

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 !