[ADiamond]

having some formatting issues with excel which im trying to accomplish for integration maybe one of you can help?

i have a file with account numbers in one column. the account # is how the platform will associate the transaction to its respective account when i map it.

when the file was converted to .csv format, the format of the numbers switched to "scientific format" this changed a common account number into something like "6.03634E+15."

when i tried to format the cell back to "numeric" or "general" format, is changed the data to "6036335090044000"

this is not the correct full account number it should end in 90044009, et al.

any idears?

[northstarmf]

1. Try to retype the correct number in the space that was changed
2. Reformat to "Text" and again, retype the number
Still doesn't work, go back to your original .xls file format

[mcaguru]

I always knew you were brainy Maisie!

[ADiamond]

1. Try to retype the correct number in the space that was changed
2. Reformat to "Text" and again, retype the number
Still doesn't work, go back to your original .xls file format

yes going back to .xsl was recommended but the problem is that my platform wont map .xls only .csv. and i dont want to retype the account numbers, the whole point of this is to avoid doing any manual data input.

any other options? i appreciate your input thank you please follow up

[RogueCaliISO]

anthony - if you let me see the portion of your file thats giving you the issue I might be able to fix it

[bizzcash.com]

having some formatting issues with excel which im trying to accomplish for integration maybe one of you can help?

i have a file with account numbers in one column. the account # is how the platform will associate the transaction to its respective account when i map it.

when the file was converted to .csv format, the format of the numbers switched to "scientific format" this changed a common account number into something like "6.03634E+15."

when i tried to format the cell back to "numeric" or "general" format, is changed the data to "6036335090044000"

this is not the correct full account number it should end in 90044009, et al.

any idears?

AD: You may actually be getting the full Account Number but the "field" may not be "wide" enough to accommodate the data.

Please try to increase the "width" of the field by placing cursor at the top of the graph, at the lines between the alphabets, until you get a cross. Ok, let's call it a "t."

When you get the t, hold down left side cursor to access the field parameters. Drag right to increase the width. This may permit viewing of the full number.

This will, however, decrease the field legnth available for your other columns depending upon which column data are most important and the paper size/type (portrait, landscape, etc.)

It also sounds as if the system could be reverting to the basic settings on import of your data. You can ensure that the basic field settings are adjusted to accommodate your longer numbers, probably in "preferences" or similar setting. gotta go. lmk.

[Fielding Mellish]

Instead of opening the file in Excel like any other file, you need to import it using the "From Text" button in the "Get External Data" box on the Data tab.

You probably need to select "Delimited" on the first screen of the Import Wizard, then Tab and Comma on the second screen, then apply the Column data format "Text" to the appropriate columns.