?
Solved

Multiple conversions text to columns

Posted on 2013-11-08
2
Medium Priority
?
149 Views
Last Modified: 2013-11-08
Hi Excel states you can only convert one column at a time using text to columns

I need to convert multiple columns from text to numeric, is there a piece of code i can run to achieve this?

Many thanks
0
Comment
Question by:Seamus2626
2 Comments
 
LVL 54

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 39633076
Hi,

You do not need to code you could copy a cell with the value 1

and then PasteSpecial/ Values - Multiply to convert Text in Numbers

Regards
0
 

Author Closing Comment

by:Seamus2626
ID: 39633105
Thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question