View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Strange "paste" behaviour

Sure the cells are not just formatted to show no decimal values. If you
select the cell manually and look in the formula bar, do you see the original
decimal/floating point value?

--
Regards,
Tom Ogilvy


" wrote:

Hi all,

I have a problem with pasting a tab-delimited text file
programmatically into a worksheet, e.g. by using
Worksheet.Paste(Range, Type.Missing) (I use C# and Office 2000). It
basically does not recognize floating numbers, e.g. they turn out as
integeres. However, if paste the file via short-cut Ctr-V or the paste
command from the toolbar, everything works fine.

Thanks,
Carl