ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Limit of text in cell. (https://www.excelbanter.com/excel-discussion-misc-queries/52348-limit-text-cell.html)

a94andwi

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


Gary''s Student

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



RagDyeR

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




All times are GMT +1. The time now is 12:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com