| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Limit of text in cell.
Hello. I've noticed a limit of text in cells. Is there a way to change this? The input in a cell is like this: "Utnyttja VSIB (Scorecard) samt Service level underlag för PipeChain leverantörer för faktabaserad bedömning, samt att alltid informera leverantörer att de kan få tillgång till Scorecard och därmed inbjuda leverantören till en mer aktiv roll i ett eventuellt förbättringsarbete" Swedish I have formated the cell to wordwrap but it only shows ######### Can I change it? -- a94andwi ------------------------------------------------------------------------ a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077 View this thread: http://www.excelforum.com/showthread...hreadid=479460 |
|
#2
|
|||
|
|||
|
Limit of text in cell.
Change it to General
-- Gary''s Student "a94andwi" wrote: Hello. I've noticed a limit of text in cells. Is there a way to change this? The input in a cell is like this: "Utnyttja VSIB (Scorecard) samt Service level underlag för PipeChain leverantörer för faktabaserad bedömning, samt att alltid informera leverantörer att de kan få tillgång till Scorecard och därmed inbjuda leverantören till en mer aktiv roll i ett eventuellt förbättringsarbete" Swedish I have formated the cell to wordwrap but it only shows ######### Can I change it? -- a94andwi ------------------------------------------------------------------------ a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077 View this thread: http://www.excelforum.com/showthread...hreadid=479460 |
|
#3
|
|||
|
|||
|
Limit of text in cell.
The cell is probably formatted to Text.
Change it to General, and see what happens. There's a bug that can be "worked around" by the format change. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "a94andwi" wrote in message ... Hello. I've noticed a limit of text in cells. Is there a way to change this? The input in a cell is like this: "Utnyttja VSIB (Scorecard) samt Service level underlag för PipeChain leverantörer för faktabaserad bedömning, samt att alltid informera leverantörer att de kan få tillgång till Scorecard och därmed inbjuda leverantören till en mer aktiv roll i ett eventuellt förbättringsarbete" Swedish I have formated the cell to wordwrap but it only shows ######### Can I change it? -- a94andwi ------------------------------------------------------------------------ a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077 View this thread: http://www.excelforum.com/showthread...hreadid=479460 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change colour of Text if number in cell exceed limit | Excel Worksheet Functions | |||
| Wrap text ceases to function in Excel if cell exceeds 9 lines | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Moving text from one cell to another. | Excel Worksheet Functions | |||
Linear Mode
