Negative number formats?

G

Guest

Importing a text file into Excel. Negative #s have "<>" around them and not
recognized as #s. Any ideas on how to get them formatted as negative numbers?
 
P

Pete_UK

Highlight the cells and do Find & Replace (CTRL-H) as follows:

Find What: >
Replace With: (leave blank)
click Replace All

CTRL-H again:

Find What: <
Replace With: -
click Replace All

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Negative numbers 5
Counting consecutive negative value 7
getting #N/A when vlookup is a negative number 3
sum function 1
Negative Numbers in a Pivot Table 1
Excell - two conditions count if factors are true when negative nu 2
formula to a minimum value of zero if a negative number 2
Copied number eg 1234- to display as (1234.00) in red in Excel 2

Top