Every time i put a number with period it becomes a date and time

Left-click on a blank, unused cell somewhere off screen and then left click
on the PaintBrush icon in the tool bar, then Left-click on the cell that's
giving you trouble.......that should clear it and return the cell format to
general.

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

The other option is what is your date seperator in windows, is it a comma, change it to a / and your problems may disappear!

Regards

Dav

how do you do that?

"Dav" wrote:

>
> The other option is what is your date seperator in windows, is it a
> comma, change it to a / and your problems may disappear!
>
> Regards
>
> Dav
>
>
> --
> Dav
> ------------------------------------------------------------------------
> Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
> View this thread: http://www.excelforum.com/showthread...hreadid=519314
>
>