Any changes I make to the format aren't reflected in the cell. I had to
select worksheet and copy to a new workbook to make changes ... see datachall
post

Thanks



"thomp" wrote:

> Just a hunch here, have you tried right clicking on the cell you want to
> change and open the format cells window?
> --
> thomp
>
>
> "Michael" wrote:
>
> > Excel 2002
> > I have a sheet that contains numeric and date information. The date is being
> > shown as the integer value ie 38384 instead of 01/02/2005 (this is shown in
> > the formula bar). I can't change number formatting - increasing the number of
> > decimal places doesn't change the value displayed (this is shown as a cell
> > tip however). Any functions ie Autosum inset the function, not the result,
> > for example if I insert autosum for 8 columns it displays '=SUM(I4:I11)' and
> > not the result.
> > I can change the 'text' formatting - bold,underline,italic. I can change the
> > shading. I can't change the alignment.
> >
> > Other worksheets are fine, no protection set
> >
> > Any help gratefully received.
> >
> >