| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell automatically changing format
in excel 2000, i have a column formatted as general. if i edit the same, do
or does not chage the value of the cell, and press enter it automatically get changed to "MM/DD/YYYY" format . what could be the reason and remedy for the same. thanx in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell automatically changing format
Hi,
That sounds like Excel trying to be helpful, if you enter something that looks like a date then Excel will format it as a date. Try entering a ' in the cell before you enter your values, it won't show in the cell. Mike "YESHWANT JOSHI" wrote: in excel 2000, i have a column formatted as general. if i edit the same, do or does not chage the value of the cell, and press enter it automatically get changed to "MM/DD/YYYY" format . what could be the reason and remedy for the same. thanx in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell automatically changing format
all those cell contains formulas and so putting ' in the beginning will not
solve my problem "Mike H" wrote: Hi, That sounds like Excel trying to be helpful, if you enter something that looks like a date then Excel will format it as a date. Try entering a ' in the cell before you enter your values, it won't show in the cell. Mike "YESHWANT JOSHI" wrote: in excel 2000, i have a column formatted as general. if i edit the same, do or does not chage the value of the cell, and press enter it automatically get changed to "MM/DD/YYYY" format . what could be the reason and remedy for the same. thanx in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to stop general format automatically changing to custom | Excel Discussion (Misc queries) | |||
| Changing Font color automatically when Cell Format is Percentage | Excel Worksheet Functions | |||
| Automatically changing cell information | Excel Discussion (Misc queries) | |||
| Automatically changing stock tick quotes to decimal-price format. | Excel Worksheet Functions | |||
| Changing cell references automatically | New Users to Excel | |||
![YESHWANT JOSHI[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
