JJZolx;151870 Wrote: 
> The default format for Excel cells is 'General' and it does what it can
> to figure out the type of data automatically.  Change the format to
> type 'Text' and this should go away.


Thanks Jim - a quick test suggests that changing the format of the cell
from General to Text after it has been populated doesn't change the
appearance. However setting the format to Text BEFORE pasting in the
data fixes the problem.

You really do learn something new every day, here!

Ceejay


-- 
ceejay
------------------------------------------------------------------------
ceejay's Profile: http://forums.slimdevices.com/member.php?userid=148
View this thread: http://forums.slimdevices.com/showthread.php?t=29282

_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss

Reply via email to