PDA

View Full Version : Automatically Converting Numbers stored as text to numers



Toofan
05-01-2017, 03:15 AM
I am using an excel workbook that use a sheet ( that will copy and paste from another workbook to this workbook ) data values for analyzing data here. but all of numbers in input sheets ( that exporting from another software ) sorted as text. i want converting them all when pasting them in my analyzer workbook. is there any solution ?
thanks

mdmackillop
05-01-2017, 05:50 AM
Try PasteSpecial xlValues or formatting cells as General before copying.
Record a macro whichever gives the correct result.