Jacob: That worked - (I had not selected ALL of the columns to format as
text). However, in attempting to use the subsequent command "=LEFT(D1,2)",
the formula would not return a number. It just displayed the formula in the
cell. Do you know why that happened?

DOUG

"Jacob Skaria" wrote:

Dear Doug

From the 'Convert Text to Columns' Wizard Step 3; hold 'Shift' key and
select the two columns displayed under 'Data Preview Area'. Once selected the
background will be black and the text will be white. Then on the same window
from the group 'Column Data format' select Text and hit Finish


If this post helps click Yes
---------------
Jacob Skaria


"DOUG" wrote:

We want to use Text to Columns to divide a field with four digits into two
columns with two digits. If one of the digits begins with zero, this does
not work - (the zero drops from the display). How do we retain the lead zero
in the resulting cell?

We have tried formatting the workbook as text prior to importing and
afterward too, to no avail. FormatNumberCustom00 did nor work either.

'Suggestions?


DOUG