James_Halligan75
Active Member
Folks,
=20
I have a report which exports a category code with leading zeros to a =
csv.
When opening this csv file in excel, excel drops the leading zeros. =
There
does not appear to be a global setting in Excel where I can set the =
format as
being text rather than 'General' which assumes numeric and drops the =
leading
zero. I have tried putting leading characters on the category code (') =
and
this appears on excel file.=20
=20
Any thoughts ???
=20
Regards,
=20
James
=20
James Halligan
Senior Applications Consultant
Software Resources Ltd,
Heron House,
Corrig Road,
Sandyford,
Dublin 18.
=20
Phone +(353) 1 207 4757 (Direct)
+(353) 1 207 4700 (Switchboard)
Fax +(353) 1 207 4777=20
Email <mailto:[email protected]> [email protected]
Web <http://www.srl.ie/> www.srl.ie
=20
=20
<http://www.srl.ie/Training_schedule.htm> =20
=20
"So shines a good deed in a weary world"=20
=20
=20
I have a report which exports a category code with leading zeros to a =
csv.
When opening this csv file in excel, excel drops the leading zeros. =
There
does not appear to be a global setting in Excel where I can set the =
format as
being text rather than 'General' which assumes numeric and drops the =
leading
zero. I have tried putting leading characters on the category code (') =
and
this appears on excel file.=20
=20
Any thoughts ???
=20
Regards,
=20
James
=20
James Halligan
Senior Applications Consultant
Software Resources Ltd,
Heron House,
Corrig Road,
Sandyford,
Dublin 18.
=20
Phone +(353) 1 207 4757 (Direct)
+(353) 1 207 4700 (Switchboard)
Fax +(353) 1 207 4777=20
Email <mailto:[email protected]> [email protected]
Web <http://www.srl.ie/> www.srl.ie
=20
=20
<http://www.srl.ie/Training_schedule.htm> =20
=20
"So shines a good deed in a weary world"=20
=20