K
Kieran H
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
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