Hello,
Use the formula =trim("D2") to get rid of the spaces in the front, then
copy the formula cells and paste special values and you will have the
numbers as numbers.
Thanks, David
On Wednesday, October 11, 2017 at 10:36:37 PM UTC-7, Pravin Gunjal wrote:
>
> Dear Friends,
>
> Greetings!
>
>
Please find the attach for solution
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like
