"Style 'Currency' Not Found"

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

Gord Dibben

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
 
D

Dave Peterson

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

Dave Peterson

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

DR W

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.
 
Top