How Microsoft Graph interprets Lotus 1-2-3 number formats

Microsoft Graph

How Microsoft Graph interprets Lotus 1-2-3 number formats

Some of the content in this topic may not be applicable to some languages.

When you import data from a Lotus 1-2-3 document, Microsoft Graph converts Lotus 1-2-3 number formats as shown in the following table. Microsoft Graph attempts to convert to a format with the same number of decimal places as specified in Lotus 1-2-3. If necessary, Microsoft Graph creates a custom format that accommodates extra decimal places.

Lotus 1-2-3 format Microsoft Graph format
Fixed, 0 decimals Number, 0 decimals (0)
Fixed, 2 decimals Number, 2 decimals (0.00)
Scientific, 0 decimals Scientific, 0 decimals (0E+00)
Scientific, 2 decimals Scientific, 2 decimals (0.00E+00)
Currency, 0 decimals Currency, 0 decimals, $ symbol

($#,##0;($#,##0))

Currency, 2 decimals Currency, 2 decimals, $ symbol

($#,##0.00;($#,##0.00))

Percent, 0 decimals Percentage, 0 decimals (0%)
Percent, 2 decimals Percentage, 2 decimals (0.00%)
Comma, 0 decimals Number, 0 decimals, comma (,) thousands separator

(#,##0;(#,##0))

Comma, 2 decimals Number, 2 decimals, comma (,) thousands separator

(#,##0.00;(#,##0.00))

General General
+/- General
Date1 (dd-mmm-yy) Date, Type 4-Mar-96 (d-mmm-yy)
Date2 (dd-mmm) Date, Type 4-Mar (d-mmm)
Date3 (mmm-yy) Date, Type Mar-96 (mmm-yy)
Text Text