Hi All,

I was trying to do some reports by pulling data from the server..

Where i get the time worked on each project

like 45.00 with space in the end.. I tried Substitute(A2, " ",""), it worked but A2 which contains 45.00 is an Text column.

So what i want is when i remove the space the data should be converted to Number format & it should also retain the decimal point (i.e., .00)..

Can anyone please help on this??