Custom Date Formats Lost when Saved in “Other” Format PSS ID Number: Q69999 Article last modified on 03-11-1991 PSS database name: D_MPlan
4.00 4.01 4.20
MS-DOS
Summary:
If a cell or range of cells are formatted with any custom date formats in a Microsoft Multiplan worksheet, these custom formats will be lost when the worksheet is saved in “Other” format. This is by program design.
More Information:
To custom format a cell or range of cells, do the following:
Choose Format.
From the Format menu, choose Cells.
Select or type the range you want to apply the custom format to.
In the “format:” field, type the symbols corresponding to the custom format you want to create.
You can use any combination of format symbols and text to create a custom format up to 32 characters long. The custom format symbols are listed on page 128 of the “Microsoft Multiplan User’s Guide.”
Press ENTER.
Reference(s):
“Microsoft Multiplan User’s Guide.” Version 4.20. Pages 127-128.
Copyright Microsoft Corporation 1991.