software

Hi, I did search through lots of place, but I couldn't find any answer.

I recently re-install the OS (XP Pro) and Office(2000).
Both are save version that I used to have, I just formatted the hard
drive.
I backed up all the data, and restored them.

I have lots of Excel file, and I used have all the number field fomat
as if they are nevagive value show in red.
Now after restore the data, they are all back in black.
I can change them back opening the each file and select cells...... but
it takes so much time.

So I was wondering if there is a way to change the format of all the
existing files. I know I can put the template file in the XLStart
folder for new files.
But I want to do it for all the existing files.

Could anyone help???
I appreciate it.

Thank you.--
symyf
------------------------------------------------------------------------
symyf's Profile: www.excelforum.com/member.php...oamp;userid=34307
View this thread: www.excelforum.com/showthread...hreadid=540738