29th May 2011, 11:30 AM
|
|
Banned
|
|
Join Date: Jan 1970
Posts: 879
|
|
Quote:
|
Originally Posted by Pauls123
Gentlemen, thanks for your help. Those cells are actually formatted as "custom". Formatting to "text" didnt work. Shaun's idea gave me a #VALUE error,.................I'll keep persevering, thanks again,
Paul
|
Paul, first format the area you will paste the form to as 'text' & then paste the form as 'paste special' / 'text' - this will fix the date format issue. |