FORMAT CELLS
 

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.

FORMAT CELLS
 

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.

FORMAT CELLS
 

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.

FORMAT CELLS
 

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.

FORMAT CELLS
 

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.