Force spreadsheets to be formated a certain way

[sopclod]

Is it possible to have excel impose certain formatting on files that you open?

We get reports from a 3rd party, and they recently started providing them in
excel (.xls) format (used to be html).

Problem is, the sheets are setup to print the report on one page, which is
fine for the short ones, but the longer ones are shrunk down so much that
they are illegible.

We are working with this 3rd party on it, but that doesn't look to hopeful.
Also we do around 700 of these reports so changing the formatting each time
would be too cumbersome (the process is bad enough already).

Is there some way I can have the page setup change automatically each time?

I am using excel 2007 and the incoming sheets are in the old xls format.

Thanks in advance.

 

[Mike H]

Try this

=TEXT(J4,"hh:mm am/pm")&"-"&TEXT(K4,"hh:mm am/pm")
Mike