View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] eugene.gokhvat@gmail.com is offline
external usenet poster
 
Posts: 10
Default xlTextPrinter and Accounting format

I'm using the xlTextPrinter file format to save fixed width text
files, but I have run into a problem with "Accounting" formatted
cells.

When saved in xlTextPrinter format, the numbers in accounting formats
have all of the digits after the first comma deleted. I suspect there
may be conflict with the comma delimiter as in comma seperated values,
but I'm not completely sure.

Anyone have any experience with this? The code works perfectly in all
other cases.