New here, desperately need some basic help. Excel 16.43. need to Sum decimals but Xcel will not Sum. Always returns 0. Done all the basics with zero luck. Forgot to add. Using Apple IOS on Macbook Air.
New here, desperately need some basic help. Excel 16.43. need to Sum decimals but Xcel will not Sum. Always returns 0. Done all the basics with zero luck. Forgot to add. Using Apple IOS on Macbook Air.
Last edited by callenv; 11-28-2020 at 04:15 PM. Reason: Add info
Without seeing what you are seeing, best guess is that the "numbers" are not true numeric but text. Easy test: ensure the cell is formatted as General and no alignment is selected. If the content of the cell is left aligned, it is text, if it is right aligned, it is numeric.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Use formulas of the form =ISTEXT(A1) in a parallel column or row to distinguish text (that might look like numbers) from actual numeric values.
The format of the cell does not matter. And looks can be deceiving.
If you change a cell format from Text to a numeric format, the cell values remain type text unless and until you "re-enter" the data. For a just a few cells, you can select the cell, press function key f2, then press Enter. (The procedure might be different on a Mac. I don't know.) For a column of data, you can use Data > Text To Columns.
Thanks for the response but I have tried every single format for each/all the cells. It SUMS numbers fine but as soon as I insert the decimal it stops working. It is not a basic error. It has something to with IOS as people who have helped use Windows with no issues.
0.04466350
0.04466351
0.04466352
0.04466353
0 - this is the total with =SUM(a1:a4)
Again, Excel probably is treating the "numbers" as text, and you should use ISTEXT to confirm that.
What if you enter 0,04466350 -- use a comma for the decimal point instead of period?
The problem might be the configuration of your computer region/language options.
Alternatively, find the Excel option Use System Separators. On a PC, I click File > Options > Advance. Sorry, but I know nothing about Excel for Mac.
Ok, got it to work. Thanks for the help.
What did you do to get it to work?
I did change to commas from decimal points. There is still a challenge though as it seems to work spuriously. I will sort it out eventually.
If you type =5/3 into a cell and press Enter, what do you see? I get 1.666666667 with a decimal point ( . dot full stop ) Do you get 1,666666667 with a comma ( , ). You might see less decimal places.
If you have "comma" then want to change it to decimal point, try:
Select the range
Ctrl-H (Find and replace)
Find what:, (type comma)
Replace with:. (type dot)
OK
text-number should change to real decimal number
Quang PT
Doing this has commas not . fine with the decimal places
Ok, it's just down to your Regional Settings then. I'd have expected a full stop rather than a comma unless you're from the French speaking part of Canada.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks