FORMAT NOT DATE

  • Thread starter Thread starter FLKulchar
  • Start date Start date
F

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
 
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.
 
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
 
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.
 
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
 
Back
Top