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


Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×