FORMAT NOT DATE

[FLKulchar]

When I type 2/20 into a cell, I do NOT want it displayed
as Feb. 20; rather, I want to se 2/20...

exactly how I typed it.

How do I format the cell(s) for this to happen?

thanks,

larry

 

[Harald Staff]

Hi Larry

Preformat at Text, or enter an apostrophe first:
'2/20
Both will result in a text, the cell value will NOT be 0.1 or anything
useful for calculations.

 

[Frank Kabel]

Hi Larry
prior to your entry format the cell as 'TEXT' or enter the value with a
leading apotrophe, e.g.
'2/20

HTH
Frank

 

[John McGimpsey]

Format the cells as Text.

You can also enter the text by prefixing it with an apostrophe - the
apostrophe won't show, but will keep the parser from interpreting the
data as a date.

 

[MS]

input '2/20

the ' mark specifies text and wont convert your figures 2/20 into a date !

 

[Guest]

Larry,
You might also want to look at the available Fraction number formats.

Regards,
Mark Graesser
(e-mail address removed)

----- FLKulchar wrote: -----

When I type 2/20 into a cell, I do NOT want it displayed
as Feb. 20; rather, I want to se 2/20...

exactly how I typed it.

How do I format the cell(s) for this to happen?

thanks,

larry