Thread: number changing
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
UNIFI UNIFI is offline
external usenet poster
 
Posts: 3
Default number changing

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