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 to delete a scenario in excel?
What is logical function in ms excel?
What is the difference between microsoft access and microsoft excel?
Where is data validation in excel?
Is excel a function?
What does ref mean in excel?
What are the benefits of learning excel?
How do I extract text from the middle in excel?
Why is vba used in excel?
What is vlookup used for in excel?
What is range name in excel?
How do I combine data from multiple rows into one in excel?