| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Text Format problem
Hello all,
I have some cells formatted as text and when I put 256 + characters I have the problem that the cell show "############". How can I fix it without changing the format of the cells? TIA P-A |
|
#2
|
|||
|
|||
|
Try putting some line breaks (Alt-Enter) into your text every 200 or so
characters "P-A Caron" wrote: Hello all, I have some cells formatted as text and when I put 256 + characters I have the problem that the cell show "############". How can I fix it without changing the format of the cells? TIA P-A |
|
#3
|
|||
|
|||
|
Excel has a problem with cells formatted as text when number of characters is
between 255 and 1024(approx) Format the cells as General. Gord Dibben Excel MVP On Tue, 26 Apr 2005 10:21:04 -0700, P-A Caron wrote: Hello all, I have some cells formatted as text and when I put 256 + characters I have the problem that the cell show "############". How can I fix it without changing the format of the cells? TIA P-A |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| zero supress leading zeros when chg format from text to number | Excel Worksheet Functions | |||
| how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
| Format Painter button problem | Excel Discussion (Misc queries) | |||
| cut and paste format problem | Excel Discussion (Misc queries) | |||
Linear Mode
