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.