Go to,
<Format> <Style>
And enlarge the "Style Name" box, and click on "Currency",
And make sure there is a "check" in the Number box.
You should see the format to the right of the box.
At this point you can click on "Modify", which will bring up the regular
"Format" dialog window, where you can choose or create the exact format that
you wish to be displayed when you click on the "$" icon.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
In some of my spreadsheets, when I try to use the currency format icon (the
one with the $), I get "style 'currency' not found.
Why would this happen?