text to numbers

[jeffkirk]

having trouble converting certain numbers

[bluesky63]

Hi jeffkirk

two forumulas require for your scenario

=VALUE(A1)

=VALUE(SUBSTITUTE(A3,"-",""))


if you have other scenario then you got to use nested if loop to put in multiple conditions, or use Power Query to transform

[bebo021999]

Try:

=SUBSTITUTE(A1&"-","-","")+0

[jeffkirk]

Thanks Bebo & BlueSky