Use the below formula. Copy it down

=VALUE(TRIM(A1))

If this post helps click Yes
---------------
Jacob Skaria


"Calculate Date range" wrote:

need your urgent help

I have a list a numbers as followings with extra bank spacing at the end of
the numbers, please advice me how to set a formula to remove it

40,900.18
1,064.65
3,453.47
6,976.03
3,186.34
6,642.70
6,183.19
8,371.08
3,414.53
8,202.76
3,524.61
3,837.21
3,392.37

Thanks