I have a worksheet that contains carriage returns embedded in a cell. When I
open the sheet, I do not see these carriage returns, but my co-worker opens
the same sheet, he sees these carriage returns as control characters. There
is an option in Excel 2003 that you can set to show/hide these control
characters using the following method
Tools -> Options -> Internations tab -> Show/Hide control characters.
I checked the whole Excel 2007 to accomplish
the same task and couldn't find
anything of this sort.
Can you please let me know how I can accomplish this issue. Hope this is not
a bug in Excel 2007.