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
- 576 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How do I make rows in excel?
How do I sort in descending order in excel?
How do I cross reference two excel sheets?
How do I convert a number stored as text to a number in excel?
What is the or function in excel?
What is the use of ms excel?
How do I open an excel file?
How many functions are there in excel?
How do you create a worksheet?
Why do people use spreadsheets mostly?
Which event do you use to check whether the pivot table is modified or not?
What is the purpose of a spreadsheet?
MS Excel Microsoft 
