200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I follow the dialog to convert group of data (mix of alpha-numerics or just numerics) in a single into columns.
the data is already entered as 'text' weather aphs-num or just num.
the text to col conversion does not always convert the group of 'values' in the cell into text, as expected, but displays the numerals as i.e 5.67E+12
worksheet attached has a very small example set
any suggestions or is this Excel2010 issue?
any other ideas to convert/accomplish my goal
This issue is quite annoying but there is a little trick to help you.
Expand all of the parts using Text to Columns and then select all of the results and right-click > Format Cells > Number tab > Custom category > type 0 into the Type: input area and hit OK.
That should convert all numbers from scientific notation, which is the issue in your case, to their full version and retain the look of the text part numbers as well.
