Hi all,

Puzzle!

XL 2000 - Re text file import

A cell formatted as text containing <255 chars displays correctly
A cell formatted as text containing 255 chars and <1025 chars
displays #######
A cell formatted as text containing 1024 chars displays correctly

The cell was originally formatted as text on import to avoid losing
leading zeros and the contents of cells over 255 chars

If the cell is re-formatted as general after the import is seems to
display correctly, however I havn't tested saving or copying the file.

Do I conclude that I should set the cell to text on import and then re-
format as general afterwards?

Any thoughts

Regards

Kieran

If you have numbers in that field that need to keep their leading 0's, then yep.

But be careful. If you change the whole column back to General, then the next
change you make to one of those numeric cells with the leading 0's will not make
you happy.

Kieran H wrote:

Hi all,

Puzzle!

XL 2000 - Re text file import

A cell formatted as text containing <255 chars displays correctly
A cell formatted as text containing 255 chars and <1025 chars
displays #######
A cell formatted as text containing 1024 chars displays correctly

The cell was originally formatted as text on import to avoid losing
leading zeros and the contents of cells over 255 chars

If the cell is re-formatted as general after the import is seems to
display correctly, however I havn't tested saving or copying the file.

Do I conclude that I should set the cell to text on import and then re-
format as general afterwards?

Any thoughts

Regards

Kieran

--

Dave Peterson