Numbers aren't numeric?
It's very nice that you posted the solution.
Now Google will have it for the next person.
Al Randall wrote:
Problem resolved as follows:
Control Panel, Regional and Language options, US English, Customize, Decimal
separator was set to "blank" for numbers rather than "period". Don't know
how/when this happened. However simply changing this back to decimal (".")
resolved ALL my problems (entry as character vs numeric, formatting, font
size selection error, negative number format).
I finally discovered this on my own after calling MS tech support and having
1st level support unable to correct. 2nd level support was able to duplicate
the problem later that day and have now entered the resolution into the MS
KB.
They also refunded my $49 charge since they didn't fix it!
Thanks to all who tried to help.
Al
--
Dave Peterson
|