Currency formating problem
 

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?

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.


"Jerry" wrote:

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?

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 "ToolsOptionsInternational", 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

"IanRoy" wrote:

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.


"Jerry" wrote:

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?

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.



"Jerry" wrote:

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

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

"IanRoy" wrote:

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.



"Jerry" wrote:

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

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

"Jerry" wrote:

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

"IanRoy" wrote:

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.



"Jerry" wrote:

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