Forum Discussion

emileaboumrad's avatar
emileaboumrad
Copper Contributor
Nov 20, 2020

changing the default currency format

When I choose currency as the format of a cell, the default sign is EURO and 2 decimal points. How can i set the default to be the DOLLAR sign ($) and zero decimal points?   Thanks Emile
Excel
salighie's avatar
salighie
Copper Contributor

SergeiBaklan 

Thanks for the reply.

I probably should've mentioned that I'm an IT Professional. I've used Excel/MSO products in advanced ways for over 20 years, I'm well acquainted with _WHAT_ that button should do.

 

And what it _HAS_ done for years, on the same laptop i've been using, is change the number format to USD from Number. Now it no longer does that on two workbooks.

 

I think i've explained the two issues i'm seeing to the best of my ability, but again....

 

On two long-existing workbooks, where that [$] button had been working correctly for years, that [$] button no longer works as expected. Something is broken and it's not a PEBKAC or a PICNIC or the ID-10T virus. ... at least i hope. LOL.

 

thanks

SergeiBaklan's avatar
SergeiBaklan
MVP
May 04, 2024

salighie 

and do you have Book.xltx, Sheet.xltx in startup folder on any of machines in question?

  • salighie's avatar
    salighie
    Copper Contributor
    May 05, 2024
    No Book.xltx or Sheet.xltx to be found at all, anywhere on C:\ drive.

Resources