importing negative numbers to excel

bunton · May 15th, 2002, 01:33 PM

I import data to excel with negative number issues.

Import example is:
123-

How do I change this in Excel to look
like -123 ? Excel thinks this is text
not a numeric number.

Help!

Thank you.
C Bunton

Juan Pablo González · May 15th, 2002, 01:36 PM

Try this

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

Mark W. · May 15th, 2002, 01:38 PM

See http://www.mrexcel.com/board/viewtop...c=6421&forum=2

bunton · May 16th, 2002, 11:56 AM

Wow!!!!!!!!!!! This really works.
Thanks for the great advise!

May 15th, 2002, 01:36 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Try this =IF(RIGHT(A1)="-",-LEFT(A1,LEN(A1)-1),A1) __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 01:33 PM	#1
bunton New Member Join Date: May 2002 Posts: 2	I import data to excel with negative number issues. Import example is: 123- How do I change this in Excel to look like -123 ? Excel thinks this is text not a numeric number. Help! Thank you. C Bunton

May 15th, 2002, 01:38 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	See http://www.mrexcel.com/board/viewtop...c=6421&forum=2

May 16th, 2002, 11:56 AM	#4
bunton New Member Join Date: May 2002 Posts: 2	Wow!!!!!!!!!!! This really works. Thanks for the great advise!