| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formatting
I am working on a spreadsheet in Excel 2007 that I did not produce. There is
a DATE coumn that displays the dates in the 5 digit NUMBER format even when entered in a regular form such as 4/8/2008. I have tried reformatting the column in DATE format without any success. The sheet and workbook protection is OFF and the cells individually show no locks. Does anybody please have any idea how I can get these dates to display in the date fomat in which they were entered. BobG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting question (if cell = 0, wrap cell in quotes) | New Users to Excel | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
![BobG[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
