Format a colum help. Excel baby here...

[Heather1961]

HI
Im very new to excel I have columns of numbers and letters
the first is cost shown as
-0.60
-0.76
ect and l need to remove the minus with out doing it one by one

the second has
AU $20.00
AU $0.30
ect and l need to remove the AU again with out doing them one by one.

I also need to create a column by adding and addition + sign to each number.

Can someone help please,
thanks Heather

[noboffinme]

Hi Heather1961,

Do you have the Excel file or an example that you can post to this Forum so I can see what you're working with?

Thanks

[elayaz]

Hi

Welcome to forum. Are you looking for something like the attached..

[Heather1961]

18 $0.76 -0.73
35.75 $3.04 -1.38
27.65 $1.94 -1.16
8.5 $0.60 -1.19
15.75 $1.10 -0.68
19.95 $1.40 -1.01
1.25 $0.09 -0.33
34.52 $2.42 -1.36
23.86 $1.67 -0.87
16.95 $1.19 -0.93
37.52 $2.63 -1.58
39.75 $2.78 -1.48
34.52 $2.42 -1.36
15.75 $1.10 -0.68
39.75 $2.78 -0.36
1.25 $0.18 -1.19
15 $2.00 -1.1
27.65 $1.94 -1.55
23.79 $1.67 -1.19
37.66 $2.64 -0.75
27.65 $1.94 -1.19
13.85 $0.97 -1.06
27.65 $1.94 -1.19
31.5 $2.68 -1.19
27.65 $1.94 -1.15
27.65 $1.94 -1.51
35.6 $3.03 -0.82
40.89 $2.86 -0.87
21.5 $1.51 -1.48
23.86 $1.67 -1.19
39.75 $2.78 -1.97
27.65 $1.94 -1.61
69.7 $5.92 -2.52
39.9 $2.79 -0.93
67.8 $4.75 -1.48
16.95 $1.19 -1.01
39.75 $2.78 -1.48
19.95 $1.40 -1.21
39.75 $2.78 -1.19
28.25 $1.98 -0.87
23.86 $1.67 -1.48
27.65 $1.94 -0.36
16.95 $1.19 -1.19
23.86 $1.67 -0.93
10 $0.70 -0.87
1.25 $0.09 -0.54
13.85 $0.97 -0.33
16.95 $1.19 -0.75
38.5 $2.70 -0.93
15 $1.28 -1.22
19.95 $1.40 -0.66
39.75 $2.78 -1.01
13.68 $0.96 -1.48
32 $2.72 -0.63
39.75 $2.78 -1.07
16.95 $1.19 -1.48
29.98 $2.55 -0.93
1.25 $0.09 -0.73
35.75 $3.04 -1.02
72.65 $5.09 -0.33
32 $2.72 -1.16
41.93 $2.94 -2.48
37.52 $2.63 -1.07
15.78 $1.10 -1.53
23.79 $1.67 -1.43
39.75 $2.78 -0.91
17.8 $1.51 -1.1
17.5 $1.23 -1.48
41.93 $2.94 -0.72
16.95 $2.37 -1.53
37.52 $2.63 -1.46
45.68 $3.20 -1.43
29.98 $2.55 -1.02
29.5 $2.07 -1.62
13.5 $0.95 -1.24
32 $2.72 -0.62
20.83 $1.46 -1.07
33 $2.31 -1.03
15.78 $1.10 -1.32
28 $1.96 -0.91
32 $2.72 -1.14
35.75 $3.04 -1.07
39.75 $2.78 -0.83
21.5 $1.51 -1.16
10.5 $0.74 -1.48
17.8 $1.51 -0.82
2.72 $2.72 -0.55
4.5 $0.38 -0.73
2.83 $2.83 -0.41
15 $1.28 -1.5
16.95 $1.19 -0.93
23.86 $1.67 -0.87
75.08 $5.26 -2.58
32 $2.72 -1.07
16.5 $1.16 -0.92
1.25 $0.09 -0.33
41.93 $2.94 -1.53
27.65 $1.94 -1.19

SOME COLUMNS L NEED TO ADD A MINUS SIGN, SOME I NEED TO REMOVE AND OTHERS THEY HAVE AU$ THA NEES TO BE REMOVED.

thanks Heather

[elayaz]

Couple of questions here. Is this data is in single column or three columns. Is there any criteria to "remove" - sign and "add" - sign.

[FDibbins]

If that is 3 columns of data, highlight the data, press CTRL H (find/replace)...under Find, enter - (minus), leave Replace empty, click Replace All

As far as removing the $ sign, That is probably just formatting, try changing the formatting to general or number