If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|