I need to split a column into two columns and retain leading zeros. The data would look like this:
For example, the original cell "ha0902.3" splits so that the first cell is "ha" and the second cell should be "0902.3" but no matter what I do I get "902.3" in the second cell. Also I don't want the result to be a formula but the actual data only. What I really want is to force the format to be text and display all characters but it always seems to treat it as a number.
I have tried the "Text to Columns" button on the Data ribbon and formatted each column to text and used special formatting but nothing has worked.
I have also tried:
to get the second cell, which works except that I end up with a formula in the cell and it displays the apostrophe at the beginning - '0902.3Please Login or Register to view this content.
Because I have a huge amount of data to convert (by my own standard), I would really like to use "Text to Columns" since it is quick and clean.
Thanks,
BuzzMicron
Bookmarks