Prevent conversion to date format

  • Thread starter Thread starter Robert Lipman
  • Start date Start date
R

Robert Lipman

Hi,

In VBA, how can I set a cell to '1-0' without it being converted to
date format such as Jan-00? I don't want a macro either. I'm
actually generating Excel spreadsheets with Tcl and not VBA, but the
VBA answer should suffice.

Thanks,

Bob
 
Manually, you said you don't want a macro

Select cells and Numberformat (ctrl-1)
Apply the 'Text' item, or type a @ in Custom

or with code
rng.Numberformat = "@"

Regards,
Peter T
 
Manually, you said you don't want a macro

Select cells and Numberformat (ctrl-1)
Apply the 'Text' item, or type a @ in Custom

or with code
rng.Numberformat = "@"

Regards,
Peter T


Thanks, but I need to do it in VBA, not manually either.

Bob
 
Prefacing the entry with an apostrophe makes it a label and the following
snippet inserts the entry in the currently active cell:

Application.ActiveCell.Value = "'1-0"
 
Robert Lipman said:
Thanks, but I need to do it in VBA, not manually either.

Bob

I'm confused, you said you don't want a macro so I showed how to do it
manually, but also I posted the equivalent VBA code.

Regards,
Peter T
 
Back
Top