Hi,
Just wondering if anyone knows how to format a cell for multiline
values.

E.g. i have a cell formated with "d/m/yyyy". But if i hit Alt+Enter to
enter another line in the cell, can i format that text to "d/m/yyyy" as
well? I know i can just type in the value correctly, but i would like to
have it formatted.

Thanks.


--
gareth93
------------------------------------------------------------------------
gareth93's Profile: http://www.excelforum.com/member.php...o&userid=26578
View this thread: http://www.excelforum.com/showthread...hreadid=550916