T
Terry
I have some spreadsheets that are protected and I don't have the password to
unprotect. The spreadsheets are all in 2007 and I'm using WinXp.
The problem that I have encountered is that number formats periodically
change from number (0 decimals) to a date format. The numbers are unusable
by parts of the program, summing the numbers and counting each item.
I have tried to run a macro to programically correct the format, but that
hasn't worked. I suspect that 2007 prevents changing a protected
spreadsheet, using that method.
Any suggestions on how to get back to a number format, other than get the
password(I doubt the IT department will divulge that information)?
unprotect. The spreadsheets are all in 2007 and I'm using WinXp.
The problem that I have encountered is that number formats periodically
change from number (0 decimals) to a date format. The numbers are unusable
by parts of the program, summing the numbers and counting each item.
I have tried to run a macro to programically correct the format, but that
hasn't worked. I suspect that 2007 prevents changing a protected
spreadsheet, using that method.
Any suggestions on how to get back to a number format, other than get the
password(I doubt the IT department will divulge that information)?