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??
Bookmarks