Leading Zeros when exporting from forms [message #337384] |
Wed, 30 July 2008 13:07  |
Barry Brierley
Messages: 10 Registered: November 2004
|
Junior Member |
|
|
Hi,
When exporting from a custom form, text fields that have a leading zero are getting their leading zeros stripped off when the fnd_gfm.tsv gets exported and brought into Excel.
I've seen a suggestion that these fields need to be prefixed by "'" so that Excel doesn't try to be clever and decide what it thinks needs doing with the data. I'm sure that this would work, but I don't want to show the "'" in my form data.
Any ideas?
Thanks,
Barry
|
|
|
|
|
|
|