excel how to use function provides for the entry form

Want to enter both the date format yyyy-mm, how to set up, so that when the input format is not correct, such as the transmission into 2010/06, the show “format error”; when the input format correctly, direct show input

Excel In addition to the cell or range of cells can set conditions and check the validity of data, but also the user can select a cell or range of cells to display help of “input”, the user can enter an illegal data When prompted “error warning.” Select the cell or range of cells, click the “data → validity” command, click the “Enter Information” tab, select “Show input when the selected cell information” check box , enter a title, such as “attention”, enter the display information such as “This should be entered negative !”(), click” OK “button.After that, then selecting the cell or range of cells, Excel will automatically prompt the above information .In addition, you can also set conditions for checking the effectiveness of the cell or range of cells, and then set the “error warning” message is:select the cell or range of cells, click the “data → validity” command, Click the “error warning” tab, select the “input error warning is displayed when invalid data” check box (), select the warning style, enter a title such as “warning”, enter the error message such as “can not enter a positive number!” Then click “OK” button.After that, if you specify the cell entered a positive number, Excel will warn you “can not enter a positive number!” Sometimes we enter the double-digit figures after the decimal point, but precision as long as one, abbreviated after the show no problem, but the results are biased.The solution is:Click “Tools → Options → re-calculation”, check “to display the value shall prevail” ( ), this calculation error of the result is not.actually not on a calculation error, Display Settings rounding.Caiyong the Jiqiaotigong of Fangfa, Keyijiejue show Zhong's problem, Dan Tong Shi will Gaibian values of accuracy, the use of Excel will give you a warning before.

want to ask is what I mean, very grateful.

you can use this “data – the effectiveness of” achieve their goals, but you should enter the date format is yyyy-mm Enter yy-mm-dd date format is not the

custom format settings that can be a yyyy-mm

use the date format was already able to do, and 2010/06 the format correct it, you enter It can also turn into 2010-06