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 entered 12,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?
Submitted by: AdministratorFormat the column ahead of time to specify the format to show commas, decimal places, etc. This way you don't have to enter the comma or decimal places while keying the numbers.
Submitted by: Administrator
Submitted by: Administrator
Read Online Microsoft Excel Job Interview Questions And Answers
Top Microsoft Excel Questions
| ☺ | What are Excel Spreadsheet Number Formats? |
| ☺ | Using Excel is there a way to close all open Excel files at once instead of closing them one at a time? |
| ☺ | How do I combine different chart types into my Excel spreadsheet? |
| ☺ | In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format? |
| ☺ | How to Change the Sheet Tab Color of Excel Spreadsheets? |
Top Application Program Categories
| ☺ | AutoCAD Interview Questions. |
| ☺ | Microsoft Office Interview Questions. |
| ☺ | Microsoft Outlook Interview Questions. |
| ☺ | Microsoft Excel Interview Questions. |
| ☺ | MATLAB Interview Questions. |
