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

You might check Tools Autocorrect, and look to see if you have an entry to
replace the period with a slash.......if so, just highlight it and
Delete......

Vaya con Dios,
Chuck, CABGx3



"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