Question about Microsoft Excel Computers & Internet

1 Answer

When using excel how to get dates to automaticly update in order

With excel what is the solution to have out of order dates automatically correct to the correct order

Posted by on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 6 Answers

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.

Posted on May 02, 2014

Ad

6 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad
  • 108 Answers

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.

Posted on Jan 24, 2008

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

Posted on Feb 04, 2009

sodeep
  • 3267 Answers

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

Posted on Mar 20, 2009

dkspex
  • 86 Answers

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

Posted on May 27, 2009

  • 15 Answers

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.

Posted on Dec 02, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I am unable to get my vivofit to adjust to new daylight savings time.


  1. Confirm that your computer or mobile device displays the correct local time.
  2. Select an option:
    • Synchronize your device to a computer
      • Synchronize your device to a mobile device The time and date are updated automatically
    • The time and date are updated automatically

Nov 12, 2017 | Audio Players & Recorders

1 Answer

Explain how to set the date in the bottom right corner of my computer screen


  • Double click the time display on the bottom right of the computer screen to open the date and time properties box. Use the tabs to access settings for time, date, time zone and Web-based time updates.
  • 2 Set the clock for the correct time zone. Click the "Time zone" tab. Click the drop-down menu for time zone choices. Click the time zone choice for your area. Click a check in the box for automatic updates on daylight saving time changes. Click the "Apply" button, then the "OK" button.
  • 3 Set the correct date. Click the "Date and time" tab to show clock and calendar settings. Click the drop-down menu displaying the name of a month to change the month. Use the up-and-down arrow keys to change the year being displayed. Click on a date on the calendar image to set the date. The time can be manually set on this page also.
  • 4 Set the current time. Use the up-and-down arrow keys next to the numeric time display on the date and time page to manually set the clock. Click "Apply," then click "OK" to confirm date and time settings.
  • 5 Click the "Internet time" tab to use a Web-based clock for updates to automatically correct the time. Click the "Server" drop-down menu for listed Internet time sources. Click a check mark into the check box for automatic synchronizing. Click the "Update now" button, then click the "OK" button.

Sep 12, 2011 | Dell Dimension 4700 PC Desktop

2 Answers

I m using compaq presario cq40. when i opening my lapy igetting massage on screen ( windows 7 ,build 7600, this copy of window is not genuine) and my screen in black. so pl help mi about this.


if you have a genuine copy, make sure your date and time settings are correct and try last known-good configuration if available else repair or reinstall your OS installation

Mar 21, 2011 | Computers & Internet

1 Answer

None of the Microsoft suggestions correct error #0x80072F8F and allow me to get updates


search for updates manually. especially for installer 3.1 install it and restart your computer. Check Services and make sure windows automatic update service is set to automatic and started. Check time and Date and download the latest version of internet explorer from microsoft site. Install it and it will automatically update many root certificates for your windows. Set the security setting of internet explorer to default level and finally try to use update application of windows. It should work.

Sep 07, 2009 | HP Pavilion 510c PC Desktop

4 Answers

Setting Date And Time


By Settings/Time and Date switch Time zone updating to Manual Only. Now you can set time and date below

May 31, 2009 | Samsung S8300 Ultra Touch platinium-red...

1 Answer

Computer setting of date and time unstable


Could be a flat backup setting battery (aka cmos battery)

workarround
use a program to automatically update the clock like
NetTime available HERE

Mar 22, 2009 | HP Computers & Internet

1 Answer

Excell workbooks


You need to learn how to use the, "Paste Link," function. If you copy the spreadsheet and paste the information into a new tab in the same workbook, using the 'paste link' feature, the information on the linked pages will update automatically each time you update the page the links are based upon.

Jul 14, 2008 | Microsoft Computers & Internet

2 Answers

Excel - Automatically update invoice numbers


Yes but You need to tell your exact requirements eg. from where you would like to update your Invoice Template i.e from A Separate Database or from a Dropdown List etc

May 14, 2008 | Microsoft Excel 2000 Step by Step...

1 Answer

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.

Jan 20, 2008 | Computers & Internet

1 Answer

Want to update the dates in excel spreadsheet


Try inserting seperate entry for furture day number and then reference that entry address for program math. You will have to either use same number of days to repeat (automatic) this math or accept that it would be a single shot type math. Depending on which version of excel you are using the alert can be a sound or color change. If 97 or older, there is no alert available. 2000 isn't much better.
Easier to set furture date in orginial date block right from the start. Unless you are running the excel program continuously in the background, program will only check date when running.

Good Luck,

Jan 16, 2008 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

47 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2889 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18409 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...