J JVD Aug 29, 2003 #1 In several of the cells in my spredsheet, the text I entered turns to #### once I press enter. How can this be fixed?
In several of the cells in my spredsheet, the text I entered turns to #### once I press enter. How can this be fixed?
L Laura Cook Aug 29, 2003 #2 Increase the width of the column or go to Format ? Cell >Alignment and wrap text.
J JVD Aug 29, 2003 #3 Did all that. The cell is opened up to be very large to be able to show all the text, text wrap is selected, and ### still show up. Any other ideas? JVD
Did all that. The cell is opened up to be very large to be able to show all the text, text wrap is selected, and ### still show up. Any other ideas? JVD
J JVD Aug 29, 2003 #6 It is actual text being entered. JVD -----Original Message----- Is it actual text being entered or is it a formula calculating time? Biff . Click to expand...
It is actual text being entered. JVD -----Original Message----- Is it actual text being entered or is it a formula calculating time? Biff . Click to expand...
J JVD Aug 29, 2003 #7 That worked!! thanks JVD -----Original Message----- If the cells are formatted as "Text", try changing them to "General". -- HTH, Laura Cook Appleton, WI . Click to expand...
That worked!! thanks JVD -----Original Message----- If the cells are formatted as "Text", try changing them to "General". -- HTH, Laura Cook Appleton, WI . Click to expand...
