fixed length

  1. J

    VBA function to remove decimal AND have a fixed length

    Hello all, I am a practicing VBA'er but this one is really tricky for me. I have a set of weights that may range from .01 lb all the way to 1.5 lbs lbs all with different decimal points.. Example: Before__________After 0.1845 becomes 001845 1.054 becomes 010540 1.16 becomes 011600 1.116...
  2. M

    fixed length field - VBA

    i'm working on a VBA code in which i need to define each field as a specific length, and justify (or pad) the empty spaces. each column needs to be defined a specific length and will not change in the future. i'm thinking i need to define the range as a string, with a fixed length type...
  3. R

    Excel VB to print fix length txt file-no decimal point

    My first time posting. I need help to create a text file from Excel that can be imported into my Accounting system which requires a fixed length records. I am having trouble outputting the number fields in the correct format. These number fields must be 12 positions of which 2 are decimal places...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top