Thread: Using VB to format Excel cells
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Using VB to format Excel cells
Good chance that they are being stored as Text. If so, you can't currency
format text.

--
Regards,
Tom Ogilvy

Ed wrote in message
...
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?


Reply With QuoteReply With Quote