Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When I click the currency button, I expect it to change the cell to the
accounting format with the $ sign. However, when I click it (same is true with the "," button) all I get is a blank cell. When I look at the format via the menu it shows Type ";;", not the _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_) that I would expect to see. I've tried resetting the button via the customize toolbar option, as well as deleting the button and reinstalling off the same customize toolbar option to no avail. How do I fix this so that the "$" and "," buttons yield the expected formats I'm running Excel 2003 with SP2 on an IBM laptop running Windows XP 2002 with SP1. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comma format button decimals | Excel Discussion (Misc queries) | |||
Custom number format button | Excel Discussion (Misc queries) | |||
Insert spinning button with time format in Excel 2000? | Excel Discussion (Misc queries) | |||
format the "date" button for a header | Excel Discussion (Misc queries) | |||
Format Painter button problem | Excel Discussion (Misc queries) |