-
Automatically Converting Numbers stored as text to numbers
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
Last edited by Toofan; 05-01-2017 at 04:08 AM.
-
Try PasteSpecial xlValues or formatting cells as General before copying.
Record a macro whichever gives the correct result.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules