Question about Microsoft Office Excel 2003 for PC

# Dear Sir in column A i have the following Column A Column B (ResultColumn C ) 1 5 5 -2 7 -7 3 -9 9 -4 -10 -10 5 -2 2 in Column C i need to get only the sign changed i.e. ''-'' or ''+'' accourdingly as appearing in Column A but Column B figure should as it is. is there any formula in MS Excel for the same Request you to kindly help in getting the same immediatley Thank you for your attention to this mail Venkataramu KS

Posted by on

• ksramu76 Mar 14, 2009

Thanks a lot for the formula and support. Its working. Very greatful.

I have one more query.

I have a repeated names/ values in one column and next to that column different values in Sheet 1 . I another sheet called sheet 2 and i have set of repeated names/values. I want to get the value from Sheet 1 for all repeated & Uniuqe name/values. For Example

Sheet 1

Name
Value

A
1

B
2

C
3

D
4

A
5

A
6

Sheet 2

Name Values

A

B

C

D

A

In sheet 2 i have to get the values from Sheet 1. In sheet 2 there is unique and repeated names.

How do i get the value, is there any formula to slove this.

Thank you for your attention to this mail.

Venkataramu KS

×

• Level 1:

An expert who has achieved level 1.

• Contributor

If I understand you correctly, you are trying to reverse the sign on a column of numeric data in Excel. You should be able to use a formula in your results column (Column C?) that looks like this: =(A1*-1) That formula should reverse the sign of the values in column A.

Posted on Mar 18, 2009

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Governor:

An expert whose answer got voted for 20 times.

Hot-Shot:

An expert who has answered 20 questions.

• Expert

Put the below formula in column C1 and then drag down for other values. Please rate me if this helps. please.
=(A1* -1)

Posted on Mar 12, 2009

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).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### How do i remove the ignition lock ccylinde on a 2002 buick lasaber

Removal Procedure
Caution: This vehicle is equipped with a Supplemental Inflatable Restraint (SIR) System. Failure to follow the correct procedure could cause the following conditions:
• Air bag deployment
• Personal injury
• Unnecessary SIR system repairs
In order to avoid the above conditions, observe the following guidelines:
• Refer to SIR Component Views in order to determine if you are performing service on or near the SIR components or the SIR wiring.
• If you are performing service on or near the SIR components or the SIR wiring, disable the SIR system. Refer to Disabling the SIR System.
Disable the SIR system. Refer to Disabling the SIR System in SIR.
Caution: Unless directed otherwise, the ignition and start switch must be in the OFF or LOCK position, and all electrical loads must be OFF before servicing any electrical component. Disconnect the negative battery cable to prevent an electrical spark should a tool or equipment come in contact with an exposed electrical terminal. Failure to follow these precautions may result in personal injury and/or damage to the vehicle or its components.
Disconnect the battery negative cable. Refer to Battery Negative Cable Disconnection and Connection in Engine Electrical.
Position the steering wheel half way between the upper and lower tilt stops, if necessary.
Remove the steering wheel. Refer to Steering Wheel Replacement .
Remove the tilt lever. Refer to Tilt Lever Replacement - On Vehicle .

Remove the lower steering column trim cover retaining screws.
Remove the lower steering column trim cover.

Remove the upper steering column trim cover retaining screws (3).
Buick Ignition Lock Cylinder Replacement

Nov 09, 2016 | Buick Cars & Trucks

### How to replace steering wheel position sensor on a 2006 Cadillac DTS?

Manual Steering Column with JL4) or
Steering Wheel Position Sensor Replacement (Power Steering Column with JL4) ?
Preliminary Procedure Remove the intermediate steering shaft. Refer to Intermediate Steering Shaft Replacement .
1
2
Steering Wheel Position Sensor
Procedure Disconnect any electrical connectors as needed.
Tip
If reusing, secure the old steering wheel position sensor before removing it for proper alignment upon reinstallation. Refer to Steering Wheel Position Sensor Centering .

Callout

Component Name
Notice: Secure the steering wheel utilizing a strap to prevent rotation. Locking of the steering column will prevent damage and a possible malfunction of the SIR system. The steering wheel must be secured in position before disconnecting the following components:
?€¢
The steering column
?€¢
The intermediate shaft
?€¢
The steering gear

After disconnecting these components, do not move the front tires and wheels. Failure to follow these procedures may cause improper alignment of some components during installation and result in possible damage to the SIR coil.
Preliminary Procedure Remove the steering column. Refer to Steering Column Replacement .
1
Intermediate Steering Shaft Bolt
Procedure Remove the steering column boot seal in order to access the intermediate steering shaft bolt.
2
Intermediate Steering Shaft Nut
Notice: Refer to Fastener Notice in the Preface section.
Tighten
47 N?·m (35 lb ft)
3
Intermediate Steering Shaft
Tip
?€¢
If necessary, scribe location marks between the intermediate steering shaft and the steering column and the intermediate steering shaft and the steering gear to mark their alignment before removing.
?€¢
If replacing the intermediate steering shaft, transfer any scribe marks from the old one to the new one.

Callout

Component Name
Notice: Secure the steering wheel utilizing a strap to prevent rotation. Locking of the steering column will prevent damage and a possible malfunction of the SIR system. The steering wheel must be secured in position before disconnecting the following components:
?€¢
The steering column
?€¢
The intermediate shaft
?€¢
The steering gear

After disconnecting these components, do not move the front tires and wheels. Failure to follow these procedures may cause improper alignment of some components during installation and result in possible damage to the SIR coil.
Preliminary Procedures

1. Remove the left side instrument panel insulator panel. Refer to Instrument Panel Insulator Panel Replacement - Left Side .
2. Remove the driver knee bolster. Refer to Driver Knee Bolster Replacement .
3. Disconnect the intermediate steering shaft from the steering gear. Refer to Steering Gear Replacement .
1
Steering Column Nut (Qty: 4)
Tighten
25 N?·m (18 lb ft)
2
Steering Column
Procedure
• Disconnect any electrical connectors as needed.
• If equipped with AN3, disconnect the automatic transmission range selector cable. Refer to Automatic Transmission Range Selector Cable Replacement - Column .
• Transfer any parts as needed.
• Sep 12, 2015 | Cadillac Cars & Trucks

### Need to change the ignition switch

Steering Column Trim Cover Replacement
Removal Procedure
Caution: Refer to SIR Caution in the Preface section.
1. Disable the SIR system. Refer to SIR Disabling and Enabling in SIR.
2. Caution: Unless directed otherwise, the ignition and start switch must be in the OFF or LOCK position, and all electrical loads must be OFF before servicing any electrical component. Disconnect the negative battery cable to prevent an electrical spark should a tool or equipment come in contact with an exposed electrical terminal. Failure to follow these precautions may result in personal injury and/or damage to the vehicle or its components.
3. Disconnect the battery negative cable. Refer to Battery Negative Cable Disconnection and Connection in Engine Electrical.
4. Remove the steering wheel. Refer to Steering Wheel Replacement .
5. Remove the gap hider. Refer to Instrument Cluster Replacement in Instrument Panel, Gages, and Console.
Put the steering column in the CENTER position. Remove the tilt lever (1).
Remove the retaining screws (3) from the lower steering column trim cover. Disconnect the closeout trim cover from the lower steering column trim cover.
Remove the retaining screw (2) from the upper steering column trim cover (1).

Sep 10, 2015 | 2004 Buick LeSabre

### How to replace ignition lock cylinder

This may or may not help,but i found this

REMOVE OR DISCONNECT

1. Disable the SIR System.
2. Battery negative cable.
3. Knee bolster and IP steering column reinforcement. NOTICE: The steering column should never be supported by only the lower support bracket alone, damage to the column lower bearing adapter could result.
4. Lower support bracket from vehicle (2 bolts).
5. Upper column support from IP (2 bolts).
6. Lower steering column so that it rests on the driver seat.
7. Ignition switch wiring protector.
8. Ignition switch retaining screw and nut.
9. Ignition and turn signal switch column harness connectors from IP harness.
10. Turn signal switch connector from column harness.
11. Ignition switch, harness, and connector. Important

o DO NOT splice ignition switch wires.

INSTALL OR CONNECT

1. Ignition switch, securing with retaining screws.

o Adjust ignition switch. Steering Column Unit Repair.

2. Turn signal switch connector to column harness.
3. Ignition and turn signal switch column harness connectors to IP harness.
4. Ignition switch wiring protector.
5. Raise steering column to support bracket.
6. Two bolts to upper support bracket. Do not tighten fully at this time.
7. Bolt and nut to lower support bracket.

o Align column to instrument panel opening. A small shim (wedge) placed between the instrument panel column support bracket and the column can be used to hold the column stationary while tightening the upper support bolts.
o Upper and lower column support bolts and nuts to 27 Nm (20 ft. lbs.).

8. IP steering column reinforcement plate and knee bolster.
9. Battery negative cable.
10. Enable the SIR system.
super vag k+can v4.8

Jul 30, 2012 | 1994 Geo Prizm

### Highbeam switch

1. If equipped, disable the SIR system. Disconnect the negative battery cable.
2. Remove the upper steering column cover.
3. Remove the lower steering column cover screws and lower the steering column cover.
4. Remove the 2 switch mounting screws and remove the switch.
5. Detach all wire connectors from the combination switch. Push locking tabs to remove the wires.

To install:

1. Attach all wire connectors to the combination switch.
2. Install the combination switch to the column with the 2 attaching screws.
3. Install the lower steering column cover screws and lower steering column cover.
4. Install the upper steering column cover and attaching screws.
5. Connect the negative battery cable.
6. Enable the SIR system, if equipped.

Dec 04, 2011 | 1999 Pontiac Sunfire

### Location of signal relay 2002 lincoln ls

That sounds like the multifunction switch is the fault. The flasher on this vehicle is part of the hazzard switch. It recieves power for turn flashing from the turn signal switch. It is very common for the turnsignal (multifunction) switch to become worn and supply partial power to the flasher (hazzard switch) when not on which results in this fast clicking without any lights on. To be certian without taking out any tools whatsoever the next time the clicking happens jiggle the turn signal switch and see if it goes away or changes at all. If it does you need the turn signal switch. I'm going to include replacement instructions for that below because I am confident that is what you will need. Please ask if you have any further questions.

Caution: Unless directed otherwise, the ignition and start switch must be in the OFF or LOCK position, and all electrical loads must be OFF before servicing any electrical component. Disconnect the negative battery cable to prevent an electrical spark should a tool or equipment come in contact with an exposed electrical terminal. Failure to follow these precautions may result in personal injury and/or damage to the vehicle or its components.
Disconnect the negative battery cable.
Disable the supplemental inflatable restraints (SIR).

Remove the tilt lever.
Remove the 3 Torx® head screws from the lower column shroud (3).
Remove the upper column shroud (1) tilting up and unsnapping from the lower column shroud hinges (3).
Remove the lower column shroud (3) from the steering column (2).
Remove the Torx® head screws (1) from the multifunction switch (2).
Object Number: 442014 Size: SH

Disconnect the electrical connectors (3) from the multifunction switch (1).
Remove the multifunction switch (1) from the column (2).
Installation Procedure

Position the multifunction switch (1) on the steering column (2).
Connect the electrical connectors to the multifunction switch (1).

Install the Torx® head screw (1) to the multifunction switch (2).

Tighten
Tighten the screw to 6 N·m (53 lb in).

Install the lower column shrouds (3) to the steering column (2).
Install the upper column shroud (1) to the steering column (2).

Install the Torx® head screws to the lower steering column shroud (3).

Tighten
Tighten the screws to 2 N·m (18 lb in).
Install the tilt lever.
Enable the SIR system.
Connect the negative battery cable.
Ensure that the multifunction switch functions properly.

Mike39819.098075081

Hope helps.

Sep 15, 2011 | Lincoln LS Cars & Trucks

### How 2 replace intermediate steering shaft,Healp!!

The front wheels of the vehicle must be maintained in the straight ahead position and the steering column must be in the LOCK position before disconnecting the steering column or intermediate shaft. Failure to follow these procedures will cause improper alignment of some components during installation and result in damage to the SIR coil assembly. 1. Raise and support the vehicle. 2. Remove the stabilizer shaft. 3. Remove the tie rod ends from the steering knuckles. Caution: Failure to disconnect the intermediate shaft from the rack and pinion stub shaft can result in damage to the steering gear and/or intermediate shaft. This damage can cause loss of steering control which could result in personal injury. Notice: The front wheels of the vehicle must be maintained in the straight ahead position and the steering column must be in the LOCK position before disconnecting the steering column or intermediate shaft. Failure to follow these procedures will cause improper alignment of some components during installation and result in damage to the SIR coil assembly. 4. Disconnect the steering intermediate shaft from the steering gear.

Dec 12, 2010 | 2000 Pontiac Grand Prix

### How to replace the turn signal switch in a 1992 Cadilac?

Turn Signal Switch REMOVAL & INSTALLATION CAUTION
Some models covered by this manual may be equipped with a Supplemental Restraint System (SRS), which uses an air bag. Whenever working near any of the SRS components, such as the impact sensors, the air bag module, steering column, and instrument panel disable the SRS. Deville, Eldorado, Seville, and Fleetwood - Early Models
1. Disable the SIR system.
1. On Deville and Fleetwood, remove the left lower sound insulator. On Eldorado and Seville, remove the left side sound insulator.
2. Remove the Connector Position Assurance (CPA) and detach the yellow 2-way connector at the base of the steering column.
3. Remove the steering wheel.
4. Make sure the ignition switch is in the LOCK position to prevent the SIR coil assembly from going off-center.
2. Remove the SIR coil assembly retaining ring and the coil assembly. Allow the coil to hang freely. WARNING
The SIR coil assembly will become off-center if the steering column is separated from the steering gear and is allowed to rotate or if the centering spring is pushed down, letting the hub rotate while the coil is removed from the column.
3. Remove the wave washer.
4. Use tool J-23653-C or equivalents, to depress the shaft lock, then remove and discard the shaft lock retaining ring.
5. Remove the shaft lock.
6. Remove the turn signal canceling cam assembly.
7. Remove the upper bearing spring, upper bearing inner race seat and inner race.
8. Move the turn signal switch to the RIGHT TURN position.
9. On Deville, Fleetwood, and 1990 Eldorado, and Seville, remove the multi-function turn signal lever as follows:
1. Make sure the lever is in the OFF position.
2. Remove the access cover from the steering column housing.
3. Detach the cruise control wiring connector. Note the position of the connector when installed in the column.
4. Pull the lever straight out of the turn signal switch.
10. On Eldorado and Seville, remove the multi-function turn signal lever as follows:
1. On 1992-93 vehicles, slide the connector cover toward the front of the vehicle.
2. Unplug the electrical connector. On 1991 vehicles, note the position of the connector when installed in the column.
3. Push the lever straight in, rotate clockwise 1?4 turn and pull the lever out of the switch.
11. On Deville, Fleetwood, and Eldorado and Seville, remove the screw, button, spring, and hazard warning switch knob.
12. On Deville and Fleetwood, remove the one signal switch arm retaining screw. On Eldorado and Seville, remove the 2 signal switch arm retaining screws. Remove the signal switch arm.
13. Remove the turn signal switch retaining screws.
14. Remove the wiring protector and detach the turn signal switch connector.
15. Gently pull the wire harness through the column and remove the turn signal switch.

Nov 12, 2010 | 1992 Cadillac DeVille

### Do you have to teach your computer on1998cavalier when replacing ingition switch

I don't think so: Ignition Switch REMOVAL & INSTALLATION Fig. 1: Ignition switch mounting
CAUTION
The Supplemental Inflatable Restraint (SIR) system must be disarmed before working around the steering column. Failure to do may cause accidental deployment of the air bag, resulting in unnecessary SIR system repairs and/or personal injury.
1. Disconnect the negative battery cable.
2. If equipped, disable the SIR system.
3. Remove the steering column.
4. The ignition switch is located at the base of the steering column. Disconnect the vehicle wire harness from the ignition switch.
5. Unfasten the mounting screws, then remove the ignition switch assembly. To install: WARNING
When fasteners are removed, always reinstall them at the same location from which they were removed. If a fastener needs to be replaced, use the correct part number fastener for that application. If the correct part number is not available, a fastener of equal size and strength (or stronger) may be used. Fasteners that are to be reused, and those requiring thread locking compound will be called out. The correct torque value must be used when installing fasteners that require it. If the above conditions are not followed, parts or system damage could result.
6. Position the ignition switch assembly.
7. Install and tighten the 2 mounting screws.
8. Connect the vehicle wire harness to the switch assembly.
9. Install the steering column.
10. Enable the SIR system.
11. Connect the negative battery cable.

Sep 18, 2010 | 1998 Chevrolet Cavalier

### Got a 2000 chevy 3500 express van how do i get the old ignition switch out to replace it

remove the steering wheel , need a puller and locking ring tool, disconnect batt, turn the key to tho on position, and remove bolt that holds the tumbler in,

Nov 13, 2009 | 2000 Chevrolet 3500

## Open Questions:

#### Related Topics:

120 people viewed this question

#### Top Microsoft Computers & Internet Experts

##### micky dee

Level 3 Expert

##### Les Dickinson

Level 3 Expert