Question about Microsoft Excel for PC

1 Answer

IF I ENTER A NUMBER IN COLUM A THE DATE MUST APPEER IN COLUM B AND THE TIME IN COLUM C AUTOMATICALY

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 156 Answers

It should be date and time created from that number or current system date and time ?
Please clarify ...

Posted on Sep 16, 2017

Ad

1 Suggested Answer

6ya6ya

6ya staff

  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Date and time arror


When you turn your machine on for the first time, the display

prompts you to enter the current date and time. After entering,

it will not appear anymore.

NOTE: When turning on the machine after turning it off for a

long time, you need to reset date and time.

1 Press Menu until "Machine Setup" appears on the top line

of the display.

2 Press the scroll button ( or ) to display "Date & Time"

on the bottom line and press Enter.

3 Enter the correct time and date using the number keypad.

Month = 01 ~ 12

Day = 01 ~ 31

Year = requires four digits

Hour = 01 ~ 12 (12-hour mode)

00 ~ 23 (24-hour mode)

Minute = 00 ~ 59

NOTE: The date format may differ from country to country.

You can also use the scroll button ( or ) to move the

cursor under the digit you want to correct and enter a new

number.

4 To select "AM" or "PM" for 12-hour format, press the or

button or any number button.

When the cursor is not under the AM or PM indicator,

pressing the or button immediately moves the

cursor to the indicator.

You can change the clock mode to 24-hour format (e.g.

01:00 PM as 13:00). For details, see "Changing the Clock

Mode" on page 2.10.

5 Press Enter when the time and date on the display is

correct.

6 To return to Standby mode, press Stop/Clear.

Changing the Clock Mode

You can set your machine to display the current time using

either a 12-hour or 24-hour format.

1 Press Menu until "Machine Setup" appears on the top line

of the display.

2 Press the scroll button ( or ) until you see "Clock Mode"

on the bottom line and press Enter.

The clock mode currently set for the machine displays.

3 Press the scroll button ( or ) to select the other mode

and then press Enter to save the selection.
4 To return to Standby mode, press Stop/Clear.

May 14, 2014 | Samsung SCX 4521F All-In-One Laser Printer

1 Answer

Setting date and time on a NEC Phone 1P4WW-12TXH-A-TEL


To set the date and time manually:
1. When the handset is in idle mode, press MENU/ SELECT to
enter the main menu.
2. Press qCID or pDIR to scroll to >set date/time and then
press MENU/SELECT.
3. Press qCID or pDIR to select the month, then press
MENU/SELECT, or enter the number using the dialing keys.
4. Press qCID or pDIR to select the day, then press
MENU/SELECT, or enter the number using the dialing keys.
5. Press qCID or pDIR to select the year, then press
MENU/SELECT, or enter the number using the dialing keys,
then press MENU/SELECT to move on to set the time.
6. Press qCID or pDIR to select the hour, then press
MENU/SELECT, or enter the number using the dialing keys.
7. Press qCID or pDIR to select the minute, then press
MENU/SELECT, or enter the number using the dialing keys.
8. Press qCID or pDIR to highlight AM or PM, or press 2 for AM or
7 for PM. Then press MENU/SELECT to confirm. There is a confirmation
tone and the screen returns to the previous menu.

Apr 11, 2014 | AT&T DECT 6.0 Cordless Phone System with...

1 Answer

HOW TO SET THE TIME AND DATE ON THIS PHONE


time and date should automaticaly reset but if it doesnt try this. With the phone turned on remove the battery for about 30 to 60 sec. then put battery back in and turn phone on it should have reset the time and date. Doing this worked on my wifes phone hopefully it will work 4 yours.

Jul 14, 2011 | Cell Phones

1 Answer

Daylight savings time


it looks as if the machine does not do daylight saving automaticaly you have to change your time manually do the following.


SET THE DATE AND TIME ACCORDING TO THESE BUTTONS
[USER FUNCTIONS]-[ADMIN]-[GENERAL]-[CLOCK]-[DATE/TIME]

Mar 14, 2011 | Toshiba E-STUDIO 650 Copier

1 Answer

Please can you tell me how to change time and date. thank you. Wendy


The current time and date are shown on the display when the machine is on and ready for use (standby mode). The time and date are printed on all faxes you send.
Note: If power to the machine is cut off for over 30 minutes, when power is restored, the machine prompts you to reset the time and date.
1. Press Setup. The display shows the first setup menu; FAX NUMBER/NAME.
2. Press left arrow or right arrow until 'TIME/DATE SETUP' appears, then press
Start/Enter. The display asks you to choose a date format.
3. Press Start/Enter.
4. Press left arrow or right arrow until you find the desired date format, then press
Start/Enter.
If you select USA, the time and date appears in the order of month, day, then year. The EUROPE format will be displayed in the order of day, month, then year.
The display shows the currently set time and date using the selected date format.
5. Enter the correct time and date using the number keypad.
Day = 01~31
Month = 01~12
Year = four digits
Hour = 00~23
Minute = 00~59
You can also use left arrow or right arrow to move the cursor under the digit you want
to correct, then enter a new number.
6. Press Start/Enter when the time and date on the display is correct. If you enter an invalid number, the machine beeps and does not proceed to the next step. If this happens, just reenter the correct number.
The display shows the time and date you have set, then returns to
Standby mode.
06-25-1999 12:30 ('USA' type)

Nov 25, 2010 | Samsung SF-5100 Plain Paper Laser Fax

3 Answers

My office has the Prostar 816 phone and the manual is not detailed at all.. I needed to know how to change the time (due to time change) Our manual says #55 etc etc... Help me please!


To change the time on a prostar 816 you first need to be at a display set (doesn't matter what the extension number is).
with the handset down, enter #20 the screen should say MMC DISABLED
1) enter in 1 2 3 4 1 # (that enables programming2.gif)
2) enter in #55 the screen should say YYMMDDWHHMM
3) enter in the year, month, day, day of the week, hours and minutes(the day of the week values are 1= mon. 2= tues. etc.)
press # when finished.

Nov 12, 2009 | Samsung Prostar 824 Keyset Telephone

1 Answer

I want to set the time and date on my calculator and need help Please give me the directions


1)Press TIME/DATE and then SET (The first digit of the month will flash)2)Enter the month MM using the number keys.
(The first digit of the date will flash)
3)Enter the date DD using the number keys.
(The first digit of the year will flash)
4)Enter the year YYYY using the number keys.
(The first digit of the month will flash)
5)Press SET to confirm the date.
6)Press TIME/DATE and then SET. Enter the time using the number keys and press 12/24 to switch between 12-hour or 24-hour clock.
7)Press AM/PM to toggle morning or afternoon and press SET to confirm the time.

Oct 24, 2009 | Victor 1208-2 Calculator

1 Answer

Time date is not maintained automaticaly properly


Update the keyboard battery controller Regularly check for updated versions of the system BIOS and keyboard battery controller. To determine if an update is available for your notebook PC, go to the Drivers and Downloads site . Enter the notebook model and the keywords Update BIOS . Follow the instructions presented for your specific notebook

Jul 03, 2009 | HP Pavilion DV1049cl Notebook

1 Answer

Time


This should take care of it for you.

NOTE: The current date and time are displayed on the LCD when the machine is ON and ready for use (Standby mode). The date and time are printed on all faxes that are sent. When the machine is installed for the first time, the LCD will prompt for the date and time to be set.
  1. Press the [Setup] button on the Control Panel. 'Fax Number / Name' will be displayed on the LCD.
  2. Press the left or right arrow button until 'Time / Date Setup' is displayed, then press the [Start / Enter] button to access the Time / Date Setup menu. The LCD will prompt you to select a Date Format.
  3. Press the [Start / Enter] button.
  4. Press the left or right arrow button to select the required date format, then press [Start / Enter]. The LCD will display the currently set date and time using the selected date format and prompt to set the month. The cursor will be under the first digit of the month and the number will blink.

    NOTE: If you select USA, the date will be displayed in the format of Month-Day-Year. If you select Europe, the date will be displayed in the format of Day-Month-Year.

  5. Enter the correct date using the numeric keypad on the Control Panel. Each time you enter the appropriate number, the LCD will prompt for the next item to be entered in the following order: month, day, year, hour, and minute.
  6. Enter the correct time in 24-hour format using the numeric keypad. For example, enter 22:30 for 10:30 P.M. If an invalid number is entered, the LCD will not proceed to the next step. Re-enter the correct number.
  7. Press the [Start / Enter] button to save the setting and return to the Standby mode. The LCD will display the date and that has been set.
elem_1_spacer.gif

Dec 13, 2007 | Office Equipment & Supplies

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

Related Topics:

143 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

Peter Dragonetti

Level 3 Expert

798 Answers

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

Answer questions

Manuals & User Guides

Loading...