With excel what is the solution to have out of order dates automatically correct to the correct order
Sort the data to represent descending order for a chronological data set. If your information is listed in a table format in multiple columns, make sure you select all of the data and sort on the date field.
SOURCE: how to move entries that are place in wrong chronological order in payments section
Most mature programs would do that as well as check to make sure the date format is consistent. Since I don't know what program you are using that's all the information I can give you.
SOURCE: Increment a number per record in Microsoft Excel
For what you are talking about doing, Microsoft Access would probably be a better option. With Microsoft Access, you can create a custom form and have it automatically give a number.
More information about Access:
http://www.bcschools.net/staff/AccessHelp.htm
SOURCE: I want my clients' age to automatically calculate
Its the same only the interface is different. Use the same technique of the Mathematical algorithm keeping in mind the way the date, time are displayed in their format. Also switch to 24 Hr mode....sodeep
SOURCE: Security update, KB95995, can't collate print in Excel.
a temporary fix may be to disable automatic updates which can be done by going to security centre
>start
>control panel
.security centre
SOURCE: Word automatically updates documents
Get rid of the date field. Just type the date instead.
You can set your personal options to not update the fields under Word Options, but it doesn't stop it from updating on someone else's computer.
78 views
Usually answered in minutes!
×