Member Avatar for help distressed

Even after formatting cells as numbers their sum adds up to zero. How to correct this anomaly?

  • 2 Contributors
  • 4 Replies
  • 73 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by help distressed
Member Avatar for Reverend Jim

I'm assuming that zero is the incorrect answer? Can you please post an example with screen shot? Please include the calculation that is being used.

Edited by Reverend Jim
Member Avatar for help distressed

Cannot post a screen shot since I am not carrying my laptop in which I use Excel 2007. If two number formatted cells contain numbers say 25 and 40, their addition in a third cell returns zero and not 65.

Member Avatar for Reverend Jim

Again, we can't offer any solution or explanation without seeing the source. Imagine if you'd said "When I add 25 and 40 in Python I get a result of zero but I can't show you the code.

Can you post the spreadsheet file so I can load it up locally?

Edited by Reverend Jim
Member Avatar for help distressed

I can try that after a few days when I have access to my laptop.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.