Anyone know how to convert “-07” text to “-7” number value in google sheets?
Been hitting a wall with this, can’t find the solution on Google.
here’s the error i get
I tried =text(A1,"#") but doesn’t seem to work. It spits out the same value with the leading zero “-07”
I’m trying to do a calculation using a column of numbers that have been stripped out of a string eg. “-07” stripped from UTC-07