copied data from website, only positive data will compute.

Copper Contributor

Have attempted various "text to numeric" processes - unsuccessfully.

2 Replies

@OzzieE Well, that's rather vague.

How does the data look like when you download it? Perhaps you can provide a link to the website (if not confidential).

What "text to numeric processes" did you try?

@Riny_van_Eekelen Riny:  Determined the copied “negative “ symbol was actually a hyphen. So excel couldn’t identify as a number in my formula.

 

OzzieE