View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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