Link to home
Start Free TrialLog in
Avatar of pemurray
pemurray

asked on

SaveAs Columns Formatted As Text

Greetings all,

I have a perplexing problem.  I am not sure if it is related to Excel or PowerBuilder.  I have a datawindow with a bunch of columns (some computed fields) that I have to saveas 'HTML' with an extension of '.xls' in order to correctly save the computed fields (if you just save as Excel the computed fields are not saved).

We submit these documents to trading partners and they (multiple partners) keep coming back to us complaining that certain fields are not formatted as TEXT.  I have been formatting the fields as 'custom' with leading zeros per their specs.  Sadly, when I add the leading zeros to the datawindow, they do not show up in the 'SaveAs' HTML file.

Can someone please help me?

Thanks!!

PEM
ASKER CERTIFIED SOLUTION
Avatar of diasroshan
diasroshan
Flag of Kuwait image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pemurray
pemurray

ASKER

Rosh,

I tried it.  I bought it.  Works GREAT!!

Thank you!!

Paul