Formatting
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. |
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. |
Hi
It sounds like the cell might be formatted as text. Format it as General and then re-enter the data. Andy. "Michael" wrote in message ... 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. |
Try selecting the entire worksheet and copy it into a new worksheet. I have
encounterd similar events and this has worked for me. Bob "Andy" wrote: Hi It sounds like the cell might be formatted as text. Format it as General and then re-enter the data. Andy. "Michael" wrote in message ... 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. |
Formatting
Thanks,
this worked. "datachall" wrote: Try selecting the entire worksheet and copy it into a new worksheet. I have encounterd similar events and this has worked for me. Bob "Andy" wrote: Hi It sounds like the cell might be formatted as text. Format it as General and then re-enter the data. Andy. "Michael" wrote in message ... 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. |
Formatting
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. |
Formatting
Any formatting changes I make isn't reflected in the cells. I had to copy the
entire sheet to a new workbook to force the changes... see datachall posting. Thanks "Andy" wrote: Hi It sounds like the cell might be formatted as text. Format it as General and then re-enter the data. Andy. "Michael" wrote in message ... 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. |
Formatting
I had the same problem, try this toggle: tools - formula auditing -
formula auditing mode regards Silvia Michael wrote: 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 |
All times are GMT +1. The time now is 01:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com