MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Custom Formatting in Excel 97


Posted by David Gilson on April 29, 2000 7:19 AM

Is it possible to obtain a full listing of all the custom formats available in Excel 97?


Posted by Sherlock on May 04, 2000 9:12 PM

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