Report to Excel with Text fields
Hi,
Is there a way to force Excel to read a field as a "text" instead of
numbers when exporting a report to excel?
Or is this excel related and not report builder related?
My employee ID's are strings, and sometimes start with a 0, excel
removes the Zero and shows it as a number.
When I put a ' in the report before the 0 in the field excel reads it
as text but shows the ' ...
Can someone help?
Thankx,
Chantal
Is there a way to force Excel to read a field as a "text" instead of
numbers when exporting a report to excel?
Or is this excel related and not report builder related?
My employee ID's are strings, and sometimes start with a 0, excel
removes the Zero and shows it as a number.
When I put a ' in the report before the 0 in the field excel reads it
as text but shows the ' ...
Can someone help?
Thankx,
Chantal
This discussion has been closed.
Comments
You might try contacting the third party company that provided the Excel
export software for a quicker answer.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
I found it, if anyone else kan use this, you just have to use a Richt
text object instead of normal text field...
They are always sent to excel as text (with TExtraDevices export from
the report builder).
Chantal
On Fri, 16 May 2008 12:08:37 -0600, "Nico Cizik \(Digital Metaphors\)"