Forum Discussion
Solved
Number Sorting is not working
Hello All,
In the attached sheet , I am not able to sort Column B from low to hight in 5026ADDLoad(sorting)tab. It used to work.
Thanks,
Sam
SamFares You have used the MID function. That makes everything text. And your column B is sorted as text.
Use this in stead:
=VALUE(MID([@Mark],2,3))
5 Replies
SamFares You have used the MID function. That makes everything text. And your column B is sorted as text.
Use this in stead:
=VALUE(MID([@Mark],2,3))Thank you Riny_van_Eekelen !
Riny_van_Eekelen What i am not sure about how it worked in a different sheet( attached) without using "VALUE"
SamFares Which column is your formula in?
