Excel not recognising 1 or decimals as numbers

Hi

I have a weird problem with Excel. It recognises all numbers as numbers but excluding the number 1. It is only recognised as text as well as a decimals, for example 3.4. So every time I try and add these values up it completely ignores 1 and decimals.

Have I modified a setting?

Any help would be much appreciated.

If some of your cells are text-formatted then any "numbers" they contain will be ignored if you use a SUM function. Are the 1s and decimals generated by formulas?

The numbers are not being generated via formulas and the cell format is set to number. I wonder if the preferences for excel (if there is a file for them) has become either corrupted or another user on the machine has touched some settings I can't seem to find.

Hello joeymagic,

Does this happen only on one worksheet? Does this happen when you open known good workbooks as well?

Sincerely,
Leith Ross

Have you tried typing an equals sign in the function bar before the number, this may help distinguish it as a number to the system, despite your formatting selection.

If cells are text-formatted then changing the format to number doesn't change anything. Try this

Select column of numbers > Data > Text to columns > Finish

Does the sum work now? If not then what formula are you using to sum the values?