Dates appear as serial - can't format

  • Thread starter Thread starter mgrairy
  • Start date Start date
M

mgrairy

tried to render the dates as general (text)... it works, when i select
a cell I see a number in the formula bar (ex: 39156). then I tried to
reconvert them to dates using a macro, it works, the dates a created.
When i click on cell I see a date in the formula bar (ex 2003-02-12)

But the darn dates till show as serial in the spreadsheet... Help
 
Try
Tools|Options|View tab|uncheck formulas



tried to render the dates as general (text)... it works, when i select
a cell I see a number in the formula bar (ex: 39156). then I tried to
reconvert them to dates using a macro, it works, the dates a created.
When i click on cell I see a date in the formula bar (ex 2003-02-12)

But the darn dates till show as serial in the spreadsheet... Help
Click to expand...
 
THANKS GUYS!! problem solved! I knew it was something really
obvious... Maybe I will learn excel someday ;)

Cheers!
 
Back
Top