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

I would say, go into formatting and select text. Hope this helps.

"excelSOS" wrote:

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