I have several rows in a worksheet that are initially formated with
General (no number formatting).
However, when the user enters something like 3/8 or 3.8 Excel reads
it as a date and changes the input to its date equivalent and changes
the cell format to Custom d-mmm. This occurs allot in one particular
row as fractions are entered. I'm at a loss. I'm sure there is nothing
in my code doing this so there must be some auto format type of
setting control this but I'm unable to locate it.

Thanks for any insights.

Bill

Excel will treat an entry like 3/8 as a date. To get the fraction one
would have to enter =3/8.

As for fractions turning into dates, see if you have "Extend list
formats and formulas" checked under Tools|Options|Edit. Excel may be
trying to extend a date format into a new column.

Mark Lincoln

On Apr 24, 12:01 am, billgeo <rqtball0...@yahoo.com> wrote:
> I have several rows in a worksheet that are initially formated with
> General (no number formatting).
> However, when the user enters something like 3/8 or 3.8 Excel reads
> it as a date and changes the input to its date equivalent and changes
> the cell format to Custom d-mmm. This occurs allot in one particular
> row as fractions are entered. I'm at a loss. I'm sure there is nothing
> in my code doing this so there must be some auto format type of
> setting control this but I'm unable to locate it.
>
> Thanks for any insights.
>
> Bill

Thanks, I was check so I'll uncheck it and test it out.

Bill