View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Richard O. Neville
 
Posts: n/a
Default Every time i put a number with period it becomes a date and time

Select Format-Cells and determine the formatting of the cells in which you
are entering your numbers. It will probably say Date, "x/x/xxxx". Just
change the formatting to whatever you need, such as "General."

"excelSOS" wrote in message
...
Hi,, please help me,, everytime i put a number with a period ,, for
example
1,23 excel changes it to 1/23/2006 14:03am,,, I am going crazy because i
need to do some work and its imposible to work like this... Rgds