Thread: Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kathie Kathie is offline
external usenet poster
 
Posts: 2
Default Format

Hello,

This code presents my information as =SUM(A1:A10)
in Excel.

Range(targetcell).Formula = "=sum(" & cum & ")"


Is there a way to change the format to show the
information as =SUM(A1,A2,A3,A4)


Thank You,