Line break in cell, char(10) square settings?
 

HI all!



I have a problem regarding the char(10) square that appears when you press

"alt enter" to get a line break in a cell. (When using Wrap text)



When I use a cell reference to a cell with a line break the Char(10) square
appears in some of my excel xp or excel 2003 installations but not all of
them.



I have tried to find some settings for this but I have not.



I need the squere to get the line break back when I send the information to
a database and back



Do you have any suggestions?

Thanks,
Fredrik

Line break in cell, char(10) square settings?
 

If the cells are set to wrap text, you shouldn't get it.

If not, you probably will.

--
Regards,
Tom Ogilvy

"Fredrik Jansson" wrote in message
...
HI all!



I have a problem regarding the char(10) square that appears when you press

"alt enter" to get a line break in a cell. (When using Wrap text)



When I use a cell reference to a cell with a line break the Char(10)
square
appears in some of my excel xp or excel 2003 installations but not all of
them.



I have tried to find some settings for this but I have not.



I need the squere to get the line break back when I send the information
to
a database and back



Do you have any suggestions?

Thanks,
Fredrik

Line break in cell, char(10) square settings?
 

Thank you for the help, but

Independently if I use wrap text or not I can't see the "square" in some
installations.



If i write =CHAR(10) in a cell in one installation I get the "squere" but
in a other I cant se it no matter if I have wrap text or not.



Any suggestions?



Thanks again /Fredrik

"Tom Ogilvy" wrote in message
...
If the cells are set to wrap text, you shouldn't get it.

If not, you probably will.

--
Regards,
Tom Ogilvy

"Fredrik Jansson" wrote in message
...
HI all!



I have a problem regarding the char(10) square that appears when you
press

"alt enter" to get a line break in a cell. (When using Wrap text)



When I use a cell reference to a cell with a line break the Char(10)
square
appears in some of my excel xp or excel 2003 installations but not all
of
them.



I have tried to find some settings for this but I have not.



I need the squere to get the line break back when I send the information
to
a database and back



Do you have any suggestions?

Thanks,
Fredrik

Line break in cell, char(10) square settings?
 

I am not aware of any setting that would control this. Maybe it has to do
with the default font.

--
Regards,
Tom Ogilvy

"Fredrik Jansson" wrote in message
...
Thank you for the help, but

Independently if I use wrap text or not I can't see the "square" in some
installations.



If i write =CHAR(10) in a cell in one installation I get the "squere" but
in a other I cant se it no matter if I have wrap text or not.



Any suggestions?



Thanks again /Fredrik

"Tom Ogilvy" wrote in message
...
If the cells are set to wrap text, you shouldn't get it.

If not, you probably will.

--
Regards,
Tom Ogilvy

"Fredrik Jansson" wrote in message
...
HI all!



I have a problem regarding the char(10) square that appears when you
press

"alt enter" to get a line break in a cell. (When using Wrap text)



When I use a cell reference to a cell with a line break the Char(10)
square
appears in some of my excel xp or excel 2003 installations but not all
of
them.



I have tried to find some settings for this but I have not.



I need the squere to get the line break back when I send the
information
to
a database and back



Do you have any suggestions?

Thanks,
Fredrik