Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell format reverts to a custom date after change to General
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell format reverts to a custom date after change to General
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 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell format reverts to a custom date after change to General
Thanks, I was check so I'll uncheck it and test it out.
Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Cell Format Change from General to Custom Date | Excel Discussion (Misc queries) | |||
Automatic Format Change: General to Date | Excel Discussion (Misc queries) | |||
how i change the default format cell from date to general ? | Excel Discussion (Misc queries) | |||
Change General format to Date format | Excel Discussion (Misc queries) | |||
General Cell to Custom Date | Excel Programming |