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



(E-Mail Removed) wrote:
>
> 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

--

Dave Peterson

THANKS GUYS!! problem solved! I knew it was something really
obvious... Maybe I will learn excel someday

Cheers!

On Jun 5, 6:50 pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> Try
> Tools|Options|View tab|uncheck formulas
>
> mgra...@hotmail.com wrote:
>
> > 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
>
> --
>
> Dave Peterson