Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How do you prevent auto formating on Excel?
I'm trying to do a season records so I have scores that read 1-1 and it auto formats to Jan-1.
2 Answers
- CozmosisLv 71 decade agoFavorite Answer
Two ways...
Put a single quote in front of your score e.g. '1-1
or...
Before you enter in your scores, select the cells and format them as Text.
-Select the cells
-Right-click on one of the selected cells
-Select Format Cells
-Select Text in the category list
-OK
- ashlandLv 44 years ago
What you may desire to do is spotlight the cells you elect or the entire column in column B as an occasion. Then circulate to format, to Conditional Formatting. For difficulty a million you will exchange the alternative from "cellular cost Is" to "formula Is" and charm: =$A1="no". Then click the "format" button then the "varieties" tab and the colour you elect for "no". in case you elect it white for confident you ought to characteristic a difficulty by utilising clicking the "upload >>". persist with a similar steps from above, yet type: =$A1="confident". Then click the "format" button then the "varieties" tab and the colour you elect for "confident".
