What should be add before a fraction to avoid entering it as a date?
Answers
Answered by
1
Answer:
To prevent Excels from turning fractions into dates you must follow the steps given below :
. Select the column that will contain the fractional data .
. Right click the selection .
. Select Format Cells .
. In the number tab , under Category , select Fraction .
. Under type select upto two digits ( 15/35 ) , then click Ok .
Explanation:
HOPE THE ANSWER HELPS YOU IF SO ,
PLEASE MARK AS BRAINLIEST ....
Answered by
0
Zero space
Zero space should be add before a fraction to avoid entering it as a date.
- Fractional equation solution. A fractional equation is one that contains one or more terms that are fractions. The first step in solving a fractional equation is to eliminate the fractions by multiplying both sides of the equation by the LCD of each term.
- Choose which cells you want to format.
- Click the Dialog Box Launcher next to Number on the Home tab.
- To select a category, choose Fraction.
- Select the desired fraction format type by clicking it in the Type list.
- The "Options" link can be found by selecting the "File" tab. Scroll to "Proofing," select it, then select "AutoCorrect Options" from the list of AutoCorrect Options. Select "AutoFormat As You Type" from the tabs. To close the boxes, uncheck all of the "Replace as you type" options and click "OK."
#SPJ3
Similar questions