Thread: Problems with Dates in excel when copy and pasting
View Single Post
  #2  
Old 07-21-2006, 01:42 PM
MDubbelboer MDubbelboer is offline
Valued Forum Contributor
  
Join Date: 13 Jul 2006
Posts: 400
MDubbelboer is becoming part of the community
format your cell as a text cell either the source or the destination before pasting.

or try paste special -> values

if you're manually entering the value put a ' before the field and it'll automatically convert it to text.
Reply With Quote