Missing Decimal Places

D

Decimals

Help please,
Today when I open any excel spreadsheet all my decimals (.) have disappeared and been replaced by a space. If I go and add them in they recognize them as a period, not a decimal and I get value errors. Anyone know what has happened and how to fix it?
 
K

Ken Wright

Try Start / Control Panel / regional and language options / (Correct region??)
Hit customise and then on the Regional options tab
/ make sure decimal separator is not a space and is actually a period .

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



Decimals said:
Help please,
Today when I open any excel spreadsheet all my decimals (.) have disappeared
Click to expand...
and been replaced by a space. If I go and add them in they recognize them as a
period, not a decimal and I get value errors. Anyone know what has happened and
how to fix it?
 
Top