You must format your cells as text and also use the wrap functionality
available in the Aligment Tab under the format cells menu.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"shell" wrote:

Is it correct that cells only show 250 characters? I need a macro that will
copy all the contents of a cell and paste into a comment so the users can
read the entire block of information by hovering over the cell. I then need
this to be done automatically to each and every cell with text. I then need
the macro to update all cells and comments automatically once the cell has
been edited.

Does this make sense? Please help.