I am trying to write columns of number data from a worksheet into a text file. The data needs to be written in a specific format, and I have it stored in an array, x. I need to write it so that the first character is either a '-' (if the number is negative) or a space, followed by a single digit, a decimal point, then 6 decimal places, i.e. x0.000000, where x is either a '-' or a space. The data is all definitely between -9.999999 and 9.999999, so will fit into this format. I have tried outputting it as number format, or storing it in a string and outputting that, but I cannot get the space in-front of a positive number. Assuming that x is 1, I can either get the output as "1.000000" or "01.000000", but not " 1.000000".

I have tried:
Print #FNum, Format(x(j,i), "00.000000") and
Print #FNum, Format(x(j,i), "#0.000000")

And also putting the number into a string first:
String1 = Format(x(j,i), "00.000000")
String1 = Format(x(j,i), "@0.000000")
String1 = Format(x(j,i), "#0.000000")
String1 = Format(x(j,i), "&0.000000")

None of these give me the output I need. Can anyone please tell me the correct format statement to use?