Search form. The Federal Trade Commission (FTC) is the nationâs consumer protection agency. The FTC works to prevent fraudulent, deceptive and unfair business practices in the marketplace. Share Our Resources. Here's How >.
If you want to input today's date in Excel that will always remain up to date, use one of the following Excel date functions: = 1 TODAY() - inserts the today date in a cell. = 2 NOW() - inserts the today date and current time in a cell.
save everything and close excel. Now every time you create a new workbook it will have the desired date format you want. only step you were missing is creating a new file with pre-defined formats you want and place it in the folder of office 2010 installation folder so it opens everytime you open excel. This will solve your problem.