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?
--
anipriya

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.


"Ani.priya" wrote:

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?
--
anipriya

You can also change the formatting of the cells before (or after) you enter
12/6.
Menu - FormatCellsNumberDate, then choose format.

"Ani.priya" wrote:

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?
--
anipriya

hi,
thank you, its working. And i found another way too.. if i change that cell
to TEST format, its working.


THANKS

anipriya


"Mike H" wrote:

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.


"Ani.priya" wrote:

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?
--
anipriya

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

Regards,
Fred

"UNIFI" wrote in message
...
You can also change the formatting of the cells before (or after) you
enter
12/6.
Menu - FormatCellsNumberDate, then choose format.

"Ani.priya" wrote:

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?
--
anipriya