Hello dears
im trying to use "value" formula, to convert text to number but it dosent work for all data
attached sample
thanks in advance
Hello dears
im trying to use "value" formula, to convert text to number but it dosent work for all data
attached sample
thanks in advance
Try =A2+0 copied down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
same issue, i guess the problem is with the date format DD/MM or MM/DD
B2=IF($A2<>"",IFERROR(IF(TEXTBEFORE($A2,"-")+0<=12,VALUE($A2),SUBSTITUTE($A2,TEXTBEFORE(A2,"-"),TEXTBEFORE(TEXTAFTER($A2,"-"),"-"))+0),A2),"")
Copy down
Your dates in Column A are dd-mm-yyyy, but your VALUE function expects mm-dd-yyyy, due to local settings.
So try:Note: If your VALUE function expects dd-mm-yyyy, due to local settings this solution does not work.Formula:Please Login or Register to view this content.
In that case you need your own solution in post #1 or the solution of Glenn in post #2.
Power QueryPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks