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
- 637 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How do I replace #value with 0 in excel?
What is parsing in excel?
I am using microsoft excel 7.0 running under windows 95. I am using formulas to subtract time. If the resulting time is a negative number, the result displays aspound signs. How can I fix this?
Can you vlookup across multiple sheets?
How do you share a spreadsheet?
How to change the sheet tab color of excel spreadsheets?
What is the shortcut to delete a formula in excel?
How many rows are in one excel sheet?
How is a cell named?
How do I transfer data from one excel sheet to another?
What is the importance of ms excel?
How do I match two columns of data in excel?
MS Excel Microsoft 
