HI TOM,
THIS IS THE SECOND TIME YOU HELP ME.
THANK YOU VERY MUCH

"Tom Ogilvy" wrote:

ActiveSheet.Cells(3, 14).NumberFormat = "General"
ActiveSheet.Cells(3, 14).Value = "'3/4"


Note that the single quote at the beginning of your string will preserve it
as text - it will not display.


--
Regards,
Tom Ogilvy


"ermeko" wrote in message
...
THE TEXT IS FORMATED AS DATEVALUE. BUT I DON'T WANT THE TEXT INSERTED TO
BE
CONVERTED INTO THE DATE. AND I DON'T WANT TO USE EXCEL TOOLS.
THANKS

"John" wrote:

Change .Text to .Value

Best regards

John
"ermeko" wrote in message
...
HI,
I WANT SOME CELLS TO BE TEXT FORMATED.

ActiveSheet.Cells(3, 14).Text = "3/4"
ActiveSheet.Cells(3, 14).NumberFormat = "General"

THE ABOVE CODE DOES NOT DO WHAT IT IS SUPPOSED TO DO.
HOW CAN IT BE SOLVED?

THANKS.