number changing

  • Thread starter Thread starter Ani.priya
  • Start date Start date
A

Ani.priya

while im try to type numbers numbers like 12/6 in some cells, its
automatically converting to data format like 6-Dec, how can i avoid this?
 
Hi,

Type an apostrophe ' before you enter the data. I won't show in the cell
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
You can also change the formatting of the cells before (or after) you enter
12/6.
Menu - Format>Cells>Number>Date, then choose format.
 
hi,
thank you, its working. And i found another way too.. if i change that cell
to TEST format, its working.


THANKS

anipriya
 
Your suggestion doesn't help because the OP doesn't want a date. He wants
text.

Regards,
Fred
 
Back
Top