Computers & Internet Logo

Related Topics:

Posted on Apr 13, 2009
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

Cell Entry Formating

I am having trouble with Corel Quattro Pro program. My boss wants the entries to be in military time, however it automatically calculates it back to the standard am/pm time. I've tried to format it by clicking Format -> Selection Properties -> Numeric Format -> Time, but to no avail. Please help!

1 Answer

Dave Herard

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 152 Answers
  • Posted on Apr 16, 2009
Dave Herard
Expert
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.

Joined: Mar 18, 2009
Answers
152
Questions
0
Helped
76824
Points
386

Format the cell as hh:mm. When you put the time in the cell, input the time in the hh:mm am/pm format and it will convert to military time. ex.. (inputing 1:00 pm will convert to 13:00)

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

0helpful
1answer

2003 crown vic keyfob only works with ignition in run position .keyless entry and door locks work fine.even tried new keyfob.no change

The keyless entry system consists of the following components:
  • driver door module (DDM)
  • keyless entry transmitter
  • keyless entry keypad
The driver door module (DDM) receives inputs from the digital transmission range (TR) sensor, ignition switch, brake switch, window/door lock switches, lighting control module (LCM), keyless entry keypad switch and remote transmitter. The DDM outputs consists of keyless entry keypad switch illumination, power door lock actuators, luggage compartment release solenoid, horn relay, and lighting control module (LCM).
  • Battery junction box (BJB) fuses:
    • circuit breaker 7 (20A)
  • Central junction box (CJB)
    • 4 (10A)
    • 6 (15A)
    • 8 (25A)
    • 13 (5A)
  • Keyless entry keypad switch
  • Power door lock actuator
  • Luggage compartment release switch
  • Luggage compartment release solenoid
  • Connectors or connections
  • Wiring harness
  • If fuse's good have checked for DTC'S - diagnostic trouble codes .
  • B1526 Keyless Entry Circuit Short to Ground DDM Go To Pinpoint Test E . B1553 Decklid Release Circuit Short to Battery DDM Go To Pinpoint Test B . B1751 Park/Neutral Switch Circuit Short to Battery DDM Go To Pinpoint Test K . B2425 Remote Keyless Entry Out of Synchronization DDM Go To Pinpoint Test L Need a professional grade scan tool to check fro these codes . Not a code reader for OBD2 codes .
  • The doors do not lock/unlock using the remote transmitter
  • Remote transmitter not programmed.
  • Remote transmitter.
  • DDM.
  • Go To Pinpoint Test F .

Did you program the new key fob ?

Remote Transmitter Programming NOTE: All remote transmitters are programmable and must be set at the same time.
  1. Turn the key from OFF to RUN four times within three seconds, ending in RUN. The locks will then lock and unlock, confirming program mode has been entered.
  1. Press any button on each remote transmitter to be programmed. The doors will lock and unlock to confirm that each remote transmitter has been programmed.
  1. If additonal remote transmitters are to be programmed, repeat Step 3 within 7.5 seconds or steps 2 and 3 if more than 7.5 seconds have elapsed.
  1. To exit program mode, turn the ignition to START or wait 7.5 seconds.
  1. NOTE: Failure to wait at least 20 seconds will cause programming failures. Wait at least 20 seconds after turning the key to OFF or after the last remote transmitter has been programmed to activate a remote transmitter for testing or verification
0helpful
2answers

How can I convert quattro pro files qpw to work in excel?

put the same question in your excel help and you will have your answer
1helpful
1answer

Where can I download Quattro?

I believe you can download Quattro Pro for Windows through FTP from Corel site. ftp://ftp.corel.com/pub/QuattroPro/qpwin/
But I believe it could be 6.0.
0helpful
1answer

Cant open qpw file

You can check on the link below were you can download an converter for Quattro Pro spreadsheettrans.gif?cver=2.13.0068.3.
Note: This is an third party program (Non Microsoft program), it might help you.
http://www.pcworld.com/downloads/file/fid,3825-order,1-page,1-c,spreadsheet/description.html
Else you can also try to downloading a trial version http://www.corel.com, open your old files, save them in Excel format
0helpful
1answer

I have a Panasonic Easa-phone Model KX T-3135. I need information on how to program the memory to use the automatic dialer keys.

Panasonic ESA-PHONE - KX-T3135
Program instructions for the "Automatic Dialer"
On the right side of phone set the 'Memory' switch from 'Set' to 'Program'
If programing the upper entry of a 'Automatic Dialer' buttons:
Press the button - enter the phone number as it needs to be dialed - press the 'Memory' key on the left side of the phone's face.
If programing the lower entry of a speed dial buttons:
Press the 'lower' button on the left side at the bottom of the 'Automatic Dialer' pad;
Press the button - enter the phone number as it needs to be dialed - press the 'Memory' key on the left side of the phone's face.
When all entries are complete, on the right side of phone slide the 'Memory' switch from 'Program' to 'Set'.
May 03, 2011 • Cell Phones
1helpful
1answer

Paint Shop Pro 9 Will not Launch

Mine wasnt opening either but then I found out it wasnt because of SP3 its because i have nortons 360, i downladed the fix from there site and now it works prefect even with sp3 i guess the thing that you downlaid fixes all corel product not being able to work right with Nortons
1helpful
2answers

1999 lincoln con

SECTION 501-14B: Keyless Entry/Computer Operated Locks 1999 Town Car Workshop Manual GENERAL PROCEDURES Programming —Keyless Entry Keypad Code
  1. Enter the permanent factory keyless entry keypad code.
  1. Press the 1/2 button within five seconds to activate the programming mode. Holding the 1/2 button for more than two seconds will erase all stored customer codes. The existing codes do not need to be erased to program new codes.
  1. Enter the new five-digit keyless entry keypad code.
  1. To associate the new code with personality positions 1, 2 or 3, press the 1/2 button within 5 seconds of entering the 5th digit of the new code for position 1 or 3/4 button for position 2 or 5/6 for position 3. The door locks will lock and unlock confirming the new code is programmed.
  1. If another code is to be programmed, begin entering the code within 5 seconds of the last button pressed.
  1. After all new keyless entry codes are programmed:
    • Press keyless entry keypad buttons 7/8 and 9/0 at the same time to exit the program mode.
    • Wait for 5 seconds; the driver door module (DDM) will exit the program mode automatically.
    • -------------------------------------------------------------
Programming —Transmitter
  1. Cycle the ignition from OFF to RUN four times within three seconds. The locks will then lock and unlock, confirming program mode has been entered.
  1. NOTE: When the first keyless entry remote transmitter is programmed, all other keyless entry remote transmitters are erased.
    Press any button on the transmitter to be programmed.
  1. If additional keyless entry remote transmitters are to be programmed, repeat step 2 within 7.5 seconds.
  1. To exit program mode, turn the ignition to START or wait 7.5 seconds.
--------------------------------------------------
Programming —Remote Memory Activation NOTE: This procedure must be completed within 5 seconds.
  1. Press the SET button on the driver door panel.
  1. Press any button on the keyless entry remote transmitter to be associated with a memory setting.
  1. Press the 1 or 2 memory button on the driver door panel.
-------------------------------------------------------------
Programming —Autolock and Horn Chirp
  1. NOTE: This procedure must be completed within 30 seconds.
    Turn the ignition switch to RUN.
  1. Press the UNLOCK button three times.
  1. Turn the ignition switch to OFF.
  1. Press the UNLOCK button three times.
  1. Turn the ignition switch to RUN. The doors will lock and unlock to confirm entry into program mode.
  1. Press the UNLOCK button once to toggle the Autolock feature on or off, or twice to toggle the Horn Chirp function on or off. The horn will chirp to confirm toggling of the Autolock feature.
  1. Exit program mode by turning the ignition to OFF, START, or wait 7.5 seconds.
----------------------------------------------------------------------------------
95helpful
6answers

Quattro pro x3 abnormal program termination

1. Click Start, Programs, Accessories and Run.
2. In the open window, type: regedit and click OK.
3. Choose the following path
HKEY_CURRENT_USERS\Software\Corel\User\Assistant\13\Recent Work\Quattro
Pro\
4. Right click on the Quattro Pro folder, select delete.
5. Say yes when prompted to delete the key.
6. Close the Registry Editor
7. Launch Quattro Pro

This key will be re-created when you reopen Quattro Pro. I ran into this problem when when I tried to open a QP SS on my hard drive after previously opening one from my thumb drive. Now I copy to my hard drive first.
0helpful
1answer

One Time Entry

check your text button settings
I think it's the star button every time you hit it it will change the type of text from capital to lower case to numbers to symbles ect.
If it is not the star button look for the button with the arrow on it pointing upwards
Not finding what you are looking for?

169 views

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

Brad Brown

Level 3 Expert

19187 Answers

Cindy Wells

Level 3 Expert

6688 Answers

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

Answer questions

Manuals & User Guides

Loading...