Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
can you sort numeric address numbers by even/odd | New Users to Excel | |||
Converting Alphanumeric numbers to Numeric | Excel Worksheet Functions | |||
Split the numbers in a alpha numeric case | Excel Discussion (Misc queries) | |||
Extract Numbers from Alpha-Numeric String | Excel Worksheet Functions | |||
AVERAGE Row of Numbers and Return Corresponding Numeric Label | Excel Worksheet Functions |