Excel automatically converts some character series to the "Scientific" format. To make sure that all tokens are displayed correctly, in step 3 of the wizard changing the text to columns, select the column with the tokens and mark it as Text.
Written by Artur Zbiejcik
Updated over 2 years ago