| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format cells to show date in Australian not US format? | Excel Worksheet Functions | |||
| how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
| want format cells alignment not format cells font style | Excel Discussion (Misc queries) | |||
| Cells won't convert to number format, even after format/cells/num. | Excel Discussion (Misc queries) | |||
| When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions | |||
Linear Mode
