[thelist] Formatting cells in Excel from HTML/PHP

[Andrew Finger]

Is there a way to format cells in an Excel spreadsheet created through a web
page driven with PHP code?  I've generated the spreadsheet, but I'd like to
format cells for currency and align other cells with the decimal point to
make the spreadsheet pleasing to the eye.  The question may be posed: Are
there hidden formulae for formatting cells?

I've tried using =DOLLAR($num, 2) for currency conversion.  It works, but
when the user attempts to modify the data in the cell, the cell retains a
General format.

Andy

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963