Too True!! You probably know this already, but in the process of trying to find more information online, I stumbled across a list of predefined formats on the MSDN site, including "Scientific" incase you ever want to convert the number back, but there wasn't one that put it is standard format without round it off to 2 decimal places.

We'll have to do this again sometime!

Mike

Mike
EchoVue.com

Hi Mike,

I don't suppose you could post the URL for that list of predefined formats - it may be useful sometime!

Thanks

Andrew

http://msdn.microsoft.com/library/de.../D6/S5B22A.asp

The url above will get you to the Format Function page, which doesn't tell you much, but there is a navigation bar on the left that has links to more specialized topics. I found the number formats under Format Function Name Numeric Formats, but there are several others that are worth taking note of for future use.

Mike

Mike
EchoVue.com

Mike,

that's great thanks very much

best wishes

Andrew

Mike,

the saga went on, using write # puts quotation marks around everything so I used Print #. Unfortunately, Print # puts spaces rather than tabs between the data. Wound up creating a temporary string variable and concatenating variables and tab characters (chr(9)) into this and then using Print #


Dim Var As String
Open "MyTxtFile.txt" For Output As #1 ' Open file for output.
.
.
Var = MyVar1 & chr(9) & MyVar2 & chr(9) & etc..
Print #1, Var

etc..

Andrew