Link to home
Start Free TrialLog in
Avatar of James Rodgers
James RodgersFlag for Canada

asked on

CFCONTENT preserve leading 0's in excel

I am exporting data to an excel worksheet and i need to preserve the leading 0's in numeric data (all data should be strings in output), i added an apostrophe (') to teh output, but i shows up on the excel document

i need

0538264
to remain a string but what i am gettiing is
538264
or
'0538264

how can i specify that the output is to be a string, note i cannot use a template as teh fields are selected by teh user and i cannot guarantee which fileds will be selected.

TIA
ASKER CERTIFIED SOLUTION
Avatar of 73Spyder
73Spyder

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 James Rodgers

ASKER

was supposed to be a 250pt q


but what you said worked

thanks