Question

a club is setting up a database to store the details of its members.​

Answer 1

Answer:

mate remember 1 thing if you want to enter 0 at the beginning of any number then you need to select the cell and change it to text. like if your phone number is 0987654321 then if the data type is a number then 0 would disappear ,you need to follow the given steps to change it to text,

Add one zero in front of a number through “Format Cells”

To add the zero (0) in front of every number using the “Format Cells” option follow the below mentioned steps:

1)Select the range of mobile numbers.

2)And press the key “CTRL+1” on the keyboard.

3) The “Format Cells” dialog box will appear..

4) In the “Number” tab select “Custom” from the list.

5)In the “Type” box write 0 eleven times.

6)Click on ok.

your answers

a)number

b)Currency

c)date