problem with fields export to excel

Applications Grid / Reports
#1

hi i am making a report, i have a field with 7 positions

example “00012345”

when i run this report in the page show me fine the information “0001234” when i export to excel show me the fiel like “1234” but i need the other 3 ceros (000) i already try changing the field type, making mask and number of characters with 7 positions but same result in excel “1234” and i need “0001234”

any help?

thank you

#2

Re: problem with fields export to excel

Is the 1234 left or right justified in the XLS? Meaning does XLS see it as a numeric, even though you set the type as string in SC.

Regards,
Scott.

#3

Re: problem with fields export to excel

Hi Scott.

i the field type is text, when send to XLS justify to the left when see the field type in excel is general, already try changing in SC the type of field for numeric when export to XLS justify to the left too but without the 3 ceros and same type field general

regards

Alex.

#4

Re: problem with fields export to excel

I think you are fighting an Excel issue.
You might want to visit some site regarding this. You may need to create a Template (XLT), or see if you can send the field format somehow.
A few posts explain that importing from CSV does the same thing (removes leading zeros)

http://office.microsoft.com/en-us/excel-help/how-to-handle-leading-zeros-and-precision-in-number-codes-HA010274823.aspx

google: excel leading zero

Most of the articles detail how to do it manually, but some provide info on exporting.

Regards,
Scott.

#5

Re: problem with fields export to excel

thank you we are traying to fix via programing and template like you said, we will read the information and post the result

regards