Step by step process of making the column values between a Decimal values. NOTE: to use this skill User needs to login into Microsoft Applications.
-
1.
Open Microsoft Excel on the Web
-
2.
Click on Search Bar, Which enables the User to find the files in Outlook Excel. Type the file name, which will show recently Opened files. Once done, click on the "Next" button on the Supervity instruction widget. Open the File under the Search bar.
-
3.
Go to the Sheet Where you want to apply the Data Validation within a Number. Once done, click on the "Next" button on the Supervity instruction widget.
-
4.
Click on the Column Address where you want to apply Data Validation. Once done, click on the "Next" button on the Supervity instruction widget.
-
5.
Click on the Data Button.
-
6.
Click on Data Validation Button.
-
7.
Click on Any value Dropdown.
-
8.
Select the Decimal Option.
-
9.
Click on the Dropdown and Select the condition for the input Number. Once done, click on the "Next" button on the Supervity instruction widget.
-
10.
Enter the Details according to the condition selected. Once done, click on the "Next" button on the Supervity instruction widget.
-
11.
Click on Input Message.
-
12.
Click on Title and Enter the title to display for the user. Once done, click on the "Next" button on the Supervity instruction widget.
-
13.
Click on the Message, Enter the message you want to a display for the User. Once done, click on the "Next" button on the Supervity instruction widget.
-
14.
Click on Error Alert.
-
15.
Click on the Alert Title, and Enter the Alert title. Once done, click on the "Next" button on the Supervity instruction widget.
-
16.
Click on the Alert Message, type the Alert Message for the User. Once done, click on the "Next" button on the Supervity instruction widget.
-
17.
Click on Apply, to Apply the Settings for the above Mentioned Details.
