Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a row in a worksheet displaying dates in calendar order. Something
happened that changed the format in all the cells from m/d/y format to a number like 38596 for 9/1/2005. When I select one of these cells the date appears correctly in the formula bar. I can not reformat and get the dates to display correctly in the cells. I would like to know what hapened and how to fix it. Also, at the same time the cell width changed to a wider cell. I can not get all the cells back to their original size (smaller). I get an error message: "Object can not be shifted off sheet". -- Brent |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
run a macro in a locked cell | Excel Discussion (Misc queries) | |||
date format and the RIGHT function | Excel Worksheet Functions | |||
How to format cell with text and date. | Excel Discussion (Misc queries) | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
How do I make a blank cell with a date format blank? | Excel Worksheet Functions |