Style 'currency' not found

D

dlange

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?
 
R

RagDyeR

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?
 
D

Dave Peterson

Start a new workbook.
go back to your workbook (with the problem)

Format|Style|Merge
Point at that new workbook
Ok
Ok
(remember to save your workbook or you'll be doing this again.)

(Some how that style got deleted and you just added (merged) it back in.)
 
Top