Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I know there is a simple answer to this, but I can't seem to find it in the
help file. I am using the VBA print# statement to create a text file with numbers in right justified columns. One of the columns will contain a floating point value and I need to contol the output width of this so it lines up correctly. I don't want to use a fixed decimal point format because the output number might be anywhere in the range of 100000+ to less than 1, so I need to control the output to a fixed number of significant figures. I am sure there's a parameter where you can set the width of an output string, but I can't find it. Can anyone help? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Excel in Formatted Output | Excel Worksheet Functions | |||
Converting formatted text into a txt file | Excel Discussion (Misc queries) | |||
Open CSV file, format data and write output to a text file. | Excel Programming | |||
HELP!! Exporting formatted text file | Excel Programming | |||
CSV formatted text file to Excel | Excel Programming |