Microsoft KB Archive/69999

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.