Jul 18 2022 12:56 PM
Have attempted various "text to numeric" processes - unsuccessfully.
Jul 18 2022 08:17 PM
@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?
Jul 18 2022 08:28 PM
@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