Excel does not use format symbols. If this question is asking about arithmetic operators, the symbols are:
Excel does not use format symbols.
No....valid format symbols are (+,-,*,/ and ^)
Which of the following is a number that can be entered into a cell?
As a number format, it is a number with no specific format. The other ones, like currency, Number and Accounting allow you to do things like specify decimal places or currency symbols.
Format | Format Cell | Number Tab | Number -- Click box in front of "Use 1000 Separator" >> In Excel this type of format is known as "accounting number format"
You find scientific notation in Excel under the Format - Number menu.
The default format style that Excel assigns to all cells in a workbook is the General format. This format displays numbers as they are entered and adjusts automatically based on the content of the cell.
general format
You can format normal time to military time. For example you could have the time entered as: 13:00 If you then press Ctrl-1 to bring you to format cells and then go to Number and then Custom, you can change the format to: hmm It will now display the time as: 1300
Excel recognizes an entry as a value if it is a number or it begins with one of these symbols: +, -, =, @,#, or $ Rina
Accounting format align all the currency symbols at the left edge of the cell while Currency format align all the currency symbols them next to the number. Accounting shows a dash for zero value, Currency shows an actual zero. The actual difference is Currency has: #,##0.00_);(#,##0.00) Accounting has: _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_) ; SANJAY KISHORE
labels or cell content