View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed[_15_] Ed[_15_] is offline
external usenet poster
 
Posts: 1
Default Using VB to format Excel cells

I have a co-worker who is extracting data from SQL Server,
and using VB to create a spreadsheet. Everything is
working fine, except for the fact that he can't seem to
get the CURRENCY values to format within the spreadsheet.
He can get them to appear as numbers, with decimals but
not in CURRENCY format. Any ideas?