excel

You could do something like this:-

Say your numbers are in column A you could have a formula in column B which converts the numbers:-

=IF(RIGHT(A1,1)="C",VALUE(LEFT(A1,LEN(A1)-1)*-1),A1)

HTH,
D

The easiest way is to highlight the column, then choose "Replace" from the edit menu.
Put C in the find box
Put - in the replace box and click ok.

You could do it in a formula in another column as well, but this should be the quickest solution.

That would make 12- out of 12C. [NT]

That works great Rod thank-you just one small problem now how do I move the minus sign to the front of the number so it can read in $ format

Re: That would make 12- out of 12C. [NT]

Yep,
sorry,I read the question too quick, thought the c was preceding the number rather than following it. The formula route is the way to go. : The easiest way is to highlight the column, then choose "Replace" from the edit menu.

I'm sorry to keep asking question I really appreciate the help, I'm a little knew to excel and havnt taken any classes on it, But I'm a very quick learner, I just have a couple of questions on the formating Ive done a few things with formating but nothing like this would it be possiable if I could speak with one of you VIA IM or through e-mail ?

Anne --

You apparently carried out Rod's suggestion. You need to apply DK's suggestion, which has to be modified, as follows:

=IF(ISNUMBER(A1),A1,("-"&LEFT(A1,LEN(A1)-1))+0)

where A1 houses the first entry that must be processed. I assumed the column A as housing the entries of interest. Insert a new column next to A. Enter the formula above now in B1. Double click on the little black square (the lower right corner) of B1 in order to copy this formula down. Select all of the cells in B, copy the selection, activate A1, activate the option Edit|Paste Special >Values, then delete column B. Make a copy of your workbook before you try the foregoing procedure.

Aladin

========== : The easiest way is to highlight the column, then choose "Replace" from the edit menu.

You apparently carried out Rod's suggestion. You need to apply DK's suggestion, which has to be modified, as follows: =IF(ISNUMBER(A1),A1,("-"&LEFT(A1,LEN(A1)-1))+0) where A1 houses the first entry that must be processed. I assumed the column A as housing the entries of interest. Insert a new column next to A. Enter the formula above now in B1. Double click on the little black square (the lower right corner) of B1 in order to copy this formula down. Select all of the cells in B, copy the selection, activate A1, activate the option Edit|Paste Special >Values, then delete column B. Make a copy of your workbook before you try the foregoing procedure. Aladin ==========

I must be doing something wrong. I'm sorry if I'm sounding stupid but I havent done much with formulas. When I try and do that formula I come up with 0 do you know what i might be doing wrong

Hmm...

Copy the formula from the Formula Bar as you entered and paste it in the follow-up.

IF(ISNUMBER(B2),B2,("-"&LEFT(B2,LEN(B2)-1))+0)
I used B2 because this where my data starts. What i might be doing wrong is after I put the formula in the formula bar I'm a little lost on how to make the formula work(like i said I'm not real famillar with how this procces works). When I'm done tyring in the formula I hit the = sign and then a box pops up and then I enter ok and after that the formula appears in the cell I double click like you said and hit copy go to A2 hit paste special click on the values and that then transfers the 0

OK. Your data starts at B2.
Click on the column letter C (The whole column C gets selected by this action.).
Go to the Menu Bar at the top.
Select the option Insert|Columns (This action makes an empty column whose letter is now C. The old one has become D.).
Now,

in C2 enter: =IF(ISNUMBER(B2),B2,("-"&LEFT(B2,LEN(B2)-1))+0)

Go back to C2.

Double click on the little black square of the cell C2 (This action creates the numbers like you want them.).

Select all of the cells of C.
Do Edit|Copy.

Go to B2.

Do Edit|Paste Special >Values.

If everything is OK in B, select and delete column C.

THAT'S IT !!!!!!!! Thank-you so much you dont know how much I appreciate this THANK_YOU !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!