Sometimes that happens to me when the column is too small. Try making your column wider and seeing if that helps. You may also need to format the column data type to "date".
/S On Apr 17, 2008, at 8:37 AM, Matthew Smith wrote: > I am having a problem with a cell in a excel 2007 spreadsheet. I > am creating an inventory sheet, one excel file for each month. The > first cell has the month and year, formatted as "Jan-08" or the > like. I have created sheets for nov-07 up till apr-08 without > problem. The problem started when I got to may-08. After entering > the date as 5/1/2008, in the cell it appears as "######". I have > tried typing in "May-08" but excel converts it to a date and still > shows up as "######". Jun-08 works fine, it is just for may i am > having the problem... > > Any help would be appreciated. > > Thank you. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:258689 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
