Unable to convert some texts in to number format.
Someone please help me. File is attached with data.
Unable to convert some texts in to number format.
Someone please help me. File is attached with data.
.
Paste this into a routine module .. highlight all of the numbers only, click your button.
Please Login or Register to view this content.
another way: Clear Format, use Text2Columns, replace comma to nothing (dot to nothing if necessary) then use number format
edit:
for dates use T2C with DMY option
Last edited by sandy666; 06-08-2018 at 10:47 PM.
Its working now. Thank you all for the assistance
.
Happy we could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks