nvm

[Kalbi]

figured it out with a bunch of if's

 

[NikPreviousAcct]

http://forums.anandtech.com/categories.aspx?catid=33&flcache=2071378&entercat=y

 

[Viper GTS]

Originally posted by: Kalbi
i have a bunch of numbers where the negative is on the end, not the front (i.e. 500-)
excel is not recognizing it as negative 500

how can i make this negative 500 (i have thousands of lines so manual is last option)

Edit > Find, click the Replace tab.

Find -, replace with nothing.

And Nik it probably took less time for me to post the answer than for you to troll.

Why you continue to do that is beyond me.

Viper GTS

 

[Kalbi]

Originally posted by: Nik
http://forums.anandtech.com/categories.aspx?catid=33&flcache=2071378&entercat=y

i had a feeling YOU would be the first. they are too slow. ATOT responses are lightning fast.

 

[Kalbi]

Originally posted by: Viper GTS

Originally posted by: Kalbi
i have a bunch of numbers where the negative is on the end, not the front (i.e. 500-)
excel is not recognizing it as negative 500

how can i make this negative 500 (i have thousands of lines so manual is last option)

Edit > Find, click the Replace tab.

Find -, replace with nothing.

Viper GTS

yea but it's in the same column as the positive numbers. then all will look the same

 

[NikPreviousAcct]

Originally posted by: Viper GTS

Originally posted by: Kalbi
i have a bunch of numbers where the negative is on the end, not the front (i.e. 500-)
excel is not recognizing it as negative 500

how can i make this negative 500 (i have thousands of lines so manual is last option)

Edit > Find, click the Replace tab.

Find -, replace with nothing.

And Nik it probably took less time for me to post the answer than for you to troll.

Why you continue to do that is beyond me.

Viper GTS

That doesn't solve his problem becuase he'll have all positive numbers. He wants to move the - from the end of the number to the beginning of the number.

And I'm hardly trolling. All I'm doing is pointing him to the right forum. There are members in that forum that don't frequent OT that are Excel masters, of sorts. I've posted there before about Excel and had great results.

 

[Mean MrMustard]

Macros are your friend. More importantly, VBA.

 

[ActuaryTm]

Originally posted by: Nik
http://forums.anandtech.com/categories.aspx?catid=33&flcache=2071378&entercat=y

I concur with Nik.

You could do something along the lines of the following:

• =IF(MID(A1,LEN(A1),1)="-",-VALUE(MID(A1,1,LEN(A1)-1)),A1)

 

[Kalbi]

Originally posted by: ActuaryTm

Originally posted by: Nik
http://forums.anandtech.com/categories.aspx?catid=33&flcache=2071378&entercat=y

I concur with Nik.

You could do something along the lines of the following:

• =IF(MID(A1,LEN(A1),1)="-",-VALUE(MID(A1,1,LEN(A1)-1)),A1)

whoa wtf i will copy paste for further review thx

 

[LordSnailz]

Originally posted by: Nik

Originally posted by: Viper GTS

Originally posted by: Kalbi
i have a bunch of numbers where the negative is on the end, not the front (i.e. 500-)
excel is not recognizing it as negative 500

how can i make this negative 500 (i have thousands of lines so manual is last option)

Edit > Find, click the Replace tab.

Find -, replace with nothing.

And Nik it probably took less time for me to post the answer than for you to troll.

Why you continue to do that is beyond me.

Viper GTS

That doesn't solve his problem becuase he'll have all positive numbers. He wants to move the - from the end of the number to the beginning of the number.

And I'm hardly trolling. All I'm doing is pointing him to the right forum. There are members in that forum that don't frequent OT that are Excel masters, of sorts. I've posted there before about Excel and had great results.

Well once you have the column of positive numbers, just multitply that column by -1.

 

[NikPreviousAcct]

Originally posted by: ActuaryTm

Originally posted by: Nik
http://forums.anandtech.com/categories.aspx?catid=33&flcache=2071378&entercat=y

I concur with Nik.

You could do something along the lines of the following:

• =IF(MID(A1,LEN(A1),1)="-",-VALUE(MID(A1,1,LEN(A1)-1)),A1)

Confirmed.

 

[NikPreviousAcct]

Originally posted by: LordSnailz
Well once you have the column of positive numbers, just multitply that column by -1.

That doesn't work unless the entire column is negative numbers. If he's got thousands of columns, what are the odds that even one of them is positive?

Think.