View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Daniel is offline
external usenet poster
 
Posts: 354
Default Number Format Question

I need to write a text file with numbers in the format 5E16.9.

I have the numbers already in an array (i,j) in VBA (they are not in a
workbook cell):

columntext = arr(i, j)

how do I request these numbers to be formatted 5E16.9?

thanks
Dan