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 |