Formatting reports for Excel

[Chris Sharman]

Does anyone have any useful tips or tools for re-formatting text for Excel ?
The reports (done in Powerhouse Quiz) look fine on a VT or to print, but
oh-so-clever Excel has its own ideas about how to lay it out.

'Sparse' reports with many cells left blank seem to be a particular problem,
in that blanks seem to get removed.

Someone mentioned rich text: would it help ? Is there an encoder for VMS ?
Or is there a way to provide hints to Excel along with the reports, so that
it goes straight into Excel all pretty, rather than needing lots of manual
adjustment.

I could turn it all into comma separated quoted text, but that's fairly
tedious, and makes the report pretty unreadable except via a spreadsheet.
I'd really like a report readable to both humans & Excel.

Excel is the customer's choice, not mine, so I can't use a Powerhouse PC
product instead: the reports are done overnight & emailed to the customer
who wants to look at them with Excel first thing Monday morning.

Thanks
______________________________________________________________________
Chris Sharman			Chris.Sharman@CCAgroup.co.uk
CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.