How to stop 1/2 from turning into a date

  • Thread starter Thread starter H. Roark
  • Start date Start date
H

H. Roark

I have a user that wants to imput 1/2 into a field and it
keeps defaulting to the date Jan-2

How do you stop that from happening? He does not want the
date to show up. thanks!
 
Format the cells(s) before entering the fraction i.e.
Format, Cells, Number, Fraction (1/2)

This should do it

Peter
 
Either preformat the cell as Text or prefix the entry with an
apostrophe.

If he wants the value one-half (0.5) he can enter

0 1/2
 
Right click on the cell that you want the fraction to show
up in. From the pop up menu select "Format Cells". Select
the number Tab. Then select the formatting option
labled "Fraction". Specify how you would like to be
displayed in the "Type" box. Excel's default for fractions
is to show them as the date. Anytime you want to show
fractions in a cell, you must format it by using the above
steps.
 
Back
Top