Jump to content

keeping leading zero's on export


jbreslow
 Share

This topic is 7255 days old. Please don't post here. Open a new topic instead.

Recommended Posts

How do I keep the leading zeros on an export from FM 4.1? The field name is called "mail_code", it is a text field not a numeric field and there isn't any calculations going on.

Basically this is what the data is in the "mail_code" field:

0234

0061

0432

0003

0893

etc...

what I get:

234

61

432

3

893

HELP!!!!!

Josh

Link to comment
Share on other sites

  • 2 weeks later...

quote:

Originally posted by BobWeaver:

What software are you using to open and look at the exported file? In other words, are you sure that it isn't the target application that is stripping the leading zeroes?

Bob has a good point. For example, the standard behaviour of Excel 97, is to strip off leading zeroes, if you "drag" the file into Excel. If you import it with the File->Open command in Excel, you must change the default data type value of the column containing the values. I don't remember what it is called, sorry...

/Daniel

Link to comment
Share on other sites

This topic is 7255 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Who Viewed the Topic

    1 member has viewed this topic:
    comment 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.