While entering a series of numbers I was manually entering a comma. Excel auto-formatted the field to accommodate the comma like 1,200. I erroneously entered12,00. Obviously the comma was placed in the incorrect position, but excel interpreted this as text. When I wrote my sum formula, the results were not as expected.how can this be avoided in the future?
No Answer is Posted For this Question
Be the First to Post Answer
What are the shortcut keys of ms excel?
What is the benefit of using formula in excel sheet?
How do you create a dataset?
How can I use excel for free?
What is conditional formatting excel?
How do I draw a histogram in excel?
Is excel for android free?
Can you have two formulas in one cell excel?
How do I enlarge the view in excel?
What is text in excel?
How do you sort data in excel with formulas?
What is #value excel?