LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brent
 
Posts: n/a
Default Date format does not appear in cell

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
run a macro in a locked cell Ray Excel Discussion (Misc queries) 8 January 10th 06 12:02 AM
date format and the RIGHT function Rich Hayes Excel Worksheet Functions 0 December 19th 05 11:06 AM
How to format cell with text and date. Darlene Niebruegge Excel Discussion (Misc queries) 4 September 29th 05 02:30 PM
Imported Date & Time format with calcs. managed in excel from imrp Todd F. Excel Worksheet Functions 0 July 8th 05 09:03 PM
How do I make a blank cell with a date format blank? Pivot Table/Query Excel Worksheet Functions 6 June 14th 05 11:19 PM


All times are GMT +1. The time now is 04:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"