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

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

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

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