Custom Formatting in Excel 97

Hello,

Assuming that you need to know the custom list to format a cell in excel, we are providing you the following reply:

To obtain the list of Custom Formats available in Excel97, please follow the steps given below:
1. Open MSExcel97.
2. Go to Format -> Cells.
Format Cells window will be opened.
3. Click "Number" tab.
4. In the "Category" option choose "custom" option.On the right side of the window all types of custom formats will be displayed.

However, we are providing you the following list of custom formats available in Excel97:
General
0
0.00
#,# # 0
#,# # 0.00
#,# #0_);(#,# # 0)
#,# # 0_);[Red](#,# # 0)
#,# # 0.00_);(#,# # 0.00)
#,# # 0.00_);[Red](#, # # 0.00)
Rs.#,# # 0_);(Rs. #,# # 0)
Rs.#,# # 0_);[Red](Rs.#,# # 0)
Rs.#,# # 0.00_);(Rs.#,# # 0.00)
Rs.#,# # 0.00_);[Red](Rs.#,# # 0.00)
0%
0.00%
0.00E+00
# # 0.0E+0
# ?/?
# ??/??
mm/dd/yy
dd-mmm-yy
dd-mmm
mmm-yy
h:mm AM/PM
h:mm:ss AM/PM
h:mm
h:mm:ss
mm/dd/yy h:mm
mm:ss
mm:ss.0
@
[h]:mm:ss
_(Rs.* #,# #0_);_(Rs.*(#,# # 0);_(Rs.* "-");_(@_)
_(* #,# #0_);_(*(#,# # 0);_(* "-");_(@_)
_(Rs.* #,# #0.00_);_(Rs.*(#,# # 0.00);_(Rs.* "-"??_);_(@_)
_(* #,# #0.00_);_(*(#,# # 0.00);_(* "-"??_);_(@_)

You can also add a new entry by entering a format in the "Type" Text Box.

Hope this helps you. :-)

Regards,
Sherlock.
holmes@qsupport.com