Working With The Databases
Entering the Data In Excel Databases we can fill, correct and format the data same as any normal Worksheet or cell. We can also take the benefit of the Data Form in the Excel. You can fill the data in the any form, but keep some precautions. Firstly, in excel there no facility of field type, therefore we can fill any text, number or date in any field. Sometimes it can be a problem. If you want to write any number which starts with a zero, in Excel Databases that zero will not shown.For example: All the STD codes starts with zero. To show them correctly we have to use the Apostrophe. Secondly, If you mix the numbers text or date in any of the field, then Excel will…
