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.