Using FWRITELN() to Write a Formatted Number

Last reviewed: November 2, 1994
Article ID: Q30008

The information in this article applies to:

Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
Microsoft Excel for OS/2 versions 2.2, 2.21, and 3.0

SUMMARY

When using the FWRITELN() function to output a formatted number from a worksheet to a file, the formatting does not remain. For example, a date is written to the file as a serial number instead of in the date format used on the worksheet.

To write formatted numbers to a file, use the following formula:

   =FWRITELN(file_number,TEXT(value,format_text))

The format_text section of the formula is the format of the cell acquired from the Format Number command. For example, if the active cell on a worksheet contains 25-Mar-88, the macro formula used to write this to a file is the following:

   =FWRITELN(file_number,TEXT(ACTIVE.CELL(),"d-mmm-yy"))

For more information on the FWRITELN() and TEXT() functions, see the "Microsoft Excel Functions and Macros" manual.

KBCategory: kbusage
KBSubcategory:
Additional words: 5.00 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0
3.00 4.0 4.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.