"Style 'Currency' Not Found"

  • Thread starter Thread starter Mike Barr
  • Start date Start date
M

Mike Barr

After exporting data from ADP's ReportSmith package into
Excel, I'm unable to format cells as currency...when
attempting to do so, I receive the
message "Style 'Currency' Not Found"...any suggestions?
 
Mike

Are you using the Currency Button on the Formatting Toolbar?

It gets its settings from Format>Style>Currency.

Perhaps this style has been deleted?

What happens when you go to Format>Cells>Number>Currency?

Gord Dibben Excel MVP
 
I bet Gord is right that the style got deleted somehow.

Start a new workbook.
Go back to the problem workbook.
Format|Style|Merge|point at that new workbook
Ok your way out.
 
Is this from April?????

If yes, there was a followup:

Start a new workbook.
Go back to the problem workbook.
Format|Style|Merge|point at that new workbook
Ok your way out.
 
That worked. Yes, I tagged along on the April conversation. Your original fix wouldn't display from the website earlier today. Had a hunch it was a simple fix - if you knew how. Thanks ever so much. I learned something new I can now pass on to others also

David W.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top