Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples
New in version: 9.0   9.1   9.2   9.3   9.4   9.5   10.0   10.1   10.2   10.3    Statistic  


Writes a number into cell, but passes it as text.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
XL 10.3 Yes Yes Yes Yes Yes
MBS( "XL.Sheet.CellWriteTextAsNumber"; bookRef; sheetIndex; Row; Column; Value { ; Format } )   More


Parameter Description Example value
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
sheetIndex The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0
Row The row for the cell. First row has index 0. $row
Column The column for the cell. First column has index 0. $column
Value The new value to write. "123"
Format Optional
The format for the cell. This is index from 0 to XL.GetFormatCount-1 in the book's list of formats.


Returns OK or error.


Writes a number into cell, but passes it as text.
Avoids rounding errors with passing number as floating point value.

See also

Blog Entries

Created 26th May 2020, last changed 26th May 2020

XL.Sheet.CellWriteText   -   XL.Sheet.CellWriteTexts

Feedback: Report problem or ask question.

MBS FileMaker Plugins