Question about Microsoft Excel 2003 (065-03992) for PC

1 Answer

Hi all, this is more of a formating function issue which no one s

Seems to know. Is there a way of flipping the direction of a column of
numbers, from positive and negative values and vice versa; rather than multiplying the range by -1? Thanks. J.D.101.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 3 Answers

J.D.101 - I am not aware of any other way to reverse the signs on a list of numbers, other than multiplying those values by -1.

Posted on Mar 18, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Hi. we have copy pasted something to an excel worksheet but the auto sum doesn't work. can you help please?


Its hard to know the issue, but I suspect its due to the cell formatting not being something that can be "summed". Make sure the column(s) you are having autosum are all of the same format (numerical?)

Dec 13, 2013 | Microsoft Excel for PC

10 Answers

In Excel adding positive and negative numbers


Yes,


  1. Select the column. (click on top of the column it will select)
  2. Right Click and select Format Cells.
  3. Select Currency in Category then press OK
b6298df.gif Now just type your Numbers i.e. 571 for $571 and -650 for -$650 and sum using the normal way.

That is Select the Cells which you want to SUM and Press Alt+=

This will bring the total just below the selected cells.

Thanks
Iqbal

Apr 02, 2008 | Business & Productivity Software

1 Answer

I am trying to automatically generate serial numbers in a excel spreadsheet. I have three columns: column A is a date code under the YWW format, column B is the first serial number 00001, and column C is...


Hi JK,
We have to use the combination of dynamic list and indirect() function.
and offcourse countif() and if().

If you need the solution from me, Please send me the sample sheet on ali_zulfikar@yahoo.com so that I can send you the solution sheet.

Zulfikar Ali

Apr 06, 2010 | Microsoft Office Excel 2003 for PC

1 Answer

Change the format of dates to simple numbers


Highlight the column you'd like format as a number and copy it. Choose another column and hit Paste Special and choose Value. The date is then represented as a number.

Aug 03, 2009 | Microsoft Windows XP Professional SP3 Full...

1 Answer

I have numbers in this format 23.67- how do i


You will need to clean the "-" character at the end of the numbers - If all your number are in the same format with 6 characters simple clean or left function to remove the "-" once you have done that your new column should display all your numbers without the "-" you can either use this column in your sum function or create another column with "-" at the start so the digits are recognised as numbers and not text.

Mar 12, 2009 | Business & Productivity Software

1 Answer

How to seperate a number from a text string in microsoft excel?


highlite the cells you want. right click the mouse. go to format. select text in the first coloumn.
highlite the cells you want for the second column, right click the mouse and go to format and select number and no decimal.

Jan 28, 2009 | Business & Productivity Software

1 Answer

Countblank won't work in the column


check the format of the cell with countblank formula - it shouldn't be in date format.

Nov 23, 2008 | Microsoft Business & Productivity Software

1 Answer

Importing csc files


Hi freaks11,
I am DennisGladx and I hope to assist you.

This sounds like the Column of the data you want should be changed when you import the text file.
Right click on the column letter,
Left click on format cells from the drop down list and select the cell Con-tense you want to display.

Glad to be of assistance
please rate the solution - I can learn from your rating - Thanks

Oct 24, 2008 | Microsoft Excel for PC

1 Answer

Average handle time


I have created a spreadsheet for you to a) use and b) to learn from.

It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

It also allows you to calculate a Part Month average.

I have displayed it as it was CONSTRUCTED and as it would be USED.

The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

I have uploaded the file to here:

http://users.tpg.com.au/lesliecl/

Hope this gives you the push to really start using Excel.

Apr 04, 2008 | Microsoft Excel for PC

2 Answers

Excel function


an2net21,

The simplest solution is to use the if function.
In your example you coudl use:

=IF(A1="girl",1,0)

IF "girl" is in a1 then b2 would show as 1.
If anything else but "girl" is in a1 then b2 would show as 0.

Feb 25, 2008 | Microsoft Office Professional 2007 Full...

Not finding what you are looking for?
Microsoft Excel 2003 (065-03992) for PC Logo

48 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...