excel and carriage returns

[tim_gunning]

hi all does anyone know how to replace the carriage returns in excel ? the carriage returns are going in fine ("\r\n") and I can remove them and replace them with nothing or whatever I want, but I need to keep the carriage return so I need to know what to change it to. Excel doesnt deal with normal carriage returns and they display as little square boxes. atm I have : dr["text_value"].ToString().Replace("\r\n","[WHAT DO I CHANGE TO HERE]") this is a csv file I'm creating from a db so I just need to know what the correct value for a carraige return in excel is ? hope tat makes sense. any pointer well appreciated tia tim