Currency formating problem

[Guest]

I am having trouble getting currency to format correctly. I cannot get the
period to appear in us currency. I get $6 50 no matter what I try to change.
I have uninstalled and reinstalled Office 2003 with no change. I have also
installed all of the available updates. Any thoughts?

 

[Guest]

Hi, Jerry;
This is just a guess but at "Start> Control Panel> Regional and Language
Options> Regional Options> Customize> Currency> Decimal symbol:" what do you
see? Is there a decimal point in there? If not, does entering a decimal
point, clicking OK, and restarting Excel fix it? Let us know.
Regards;
Ian.

 

[Guest]

IanRoy,
I checked that earlier and there is a decimal point there. I have made some
progress since I sent the original post since I checked the box 'use system
seperators' in "Tools>Options>International", but now I find I cannot enter
numbers into cells such a 1 without it defaulting to 0.01. If I enter 100, I
get 1. I don't know what else I am missing.

Thanks
Jerry

 

[Guest]

Hi, Jerry;
That one sounds like it could be fixed by Tools> Options> Edit: uncheck
"Fixed decimal places." As for the other, there is a space in your example
($6 50). Could there be a space in with the decimal in your regional
settings? I was just able to replicate your symptom by unchecking "use system
separators", and the replacing the decimal point there with a space. It
wouldn't let me put both a decimal point and a space in there, though, I can
only choose one. I haven't tried this with Regional Options.
Regards,
Ian.

 

[Guest]

That solved the problem...thanks a bunch! I had the same trouble-not being
able insert the period after unchecking "use system seperators", but the
period was still in regional settings. Under cell formating it showed the
missing period and we just could not get past that.
Thanks for the help!!
Jerry

 

[Guest]

Glad to help. Thanks for letting me know it worked.