Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 0 Answers
- 664 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the #value error in excel?
What is the purpose of excel?
How do you change conditional formatting in excel?
What is range in ms excel 2007?
What are the three main applications of ms excel?
How do you find the value of a function?
How do you press the f4 key in excel?
How can I get excel to accept an entry like "5+5" without the leading equals sign as a formula? I have done this is the past but can not remember how.?
How do I count duplicate rows in excel?
What are the advantages of microsoft excel?
How do you update excel?
How do you create a drop down list in excel with filters?
MS Excel Microsoft 
