Leading Zeros and Text-to-Columns

[Ember]

Hi all,

I'm using Excel X for Mac, and I'm trying to split my four-digit dat
into two rows with two digits each:

0001 => 00|01
0101 => 01|01
9800 => 98|00

When I first imported the data it dropped all the leading zeros, bu
this was quickly remedied by making the custom format: 0000

However, if I go straight from here to text-to-columns the zeros don'
show up in the fixed-width option screen, making it impossible t
properly separate them.

Likewise, if I try to set the formatting of the cells to text, all th
leading zeros are instantly dropped.

The latter attempt - switching the formatting to text, was what I ha
understood I needed to do from reading other posts. Perhaps thi
doesn't work on Excel for Mac?

Any help appreciated, thanks

 

[Dave Peterson]

See one reply at your other post.

Hi all,

I'm using Excel X for Mac, and I'm trying to split my four-digit data
into two rows with two digits each:

0001 => 00|01
0101 => 01|01
9800 => 98|00

When I first imported the data it dropped all the leading zeros, but
this was quickly remedied by making the custom format: 0000

However, if I go straight from here to text-to-columns the zeros don't
show up in the fixed-width option screen, making it impossible to
properly separate them.

Likewise, if I try to set the formatting of the cells to text, all the
leading zeros are instantly dropped.

The latter attempt - switching the formatting to text, was what I had
understood I needed to do from reading other posts. Perhaps this
doesn't work on Excel for Mac?

Any help appreciated, thanks!