format()

[hbarker]

I am using the format function. I need to have a defined amount of characters. For instance it may read in the number 15 however the field is 7 characters long so it needs to write to a file with leading 0's. Also how do you read in decimal numbers (e.g. 3.6) and make it write to a file as 36.

Any suggestions?

[Aaron Young]

when saving your values just pad them yourself, eg.

sSaveString = Right("0000000" & Str(iValue), 7) 'e.g., iValue = 15, would result in sSaveString = "0000015"

As for the Decimal Values, Multiply the Value by 10^(No. of Decimal Places), eg.

3.6 * 10 = 36
3.25 * 100 = 325
etc..

------------------
Aaron Young
Analyst Programmer
[email protected]
[email protected]