ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Number formatting lost (https://www.excelbanter.com/excel-discussion-misc-queries/255214-number-formatting-lost.html)

PPargeter

Number formatting lost
 
I have a workbook (EXCEL 2007) with about 30 sheets. It is tracking usage of
something, so many of the column are formatted to NUMBER, 0 decimal places.
I am careful to format the column cells and to save changes before I close
the work, but every time I open the workbook, I find that the numbers have
changed to JAN-00. It is easy to change them back again, but it takes time I
do not want to use in this way. I use lots of spreadsheets (all EXCEL) and
this is the only one that does this. Can someone please help?


All times are GMT +1. The time now is 06:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com