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
How do I reduce the tab size in excel?
What are slicers in excel?
How do you clean data in excel?
Where is excel on my computer?
How are chemicals named?
What is excel shortcut keys?
Why do people use spreadsheets mostly?
What does len stand for?
How do I get the developer tab in excel?
What is the maximum row limit in excel 2010?
How do you combine two formulas?
What does ctrl f5 do in excel?