| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format
Hi Kathie,
seems straight forward to me, what problem did you have when you tried it. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kathie" wrote in message ... 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, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format
There is not a problem with the original code, I just want
to know how to change the way the formula is displayed on the Excel worksheet (through the vba code). I would like it to show up as =SUM(A1,A2,A3,A4) -----Original Message----- Hi Kathie, seems straight forward to me, what problem did you have when you tried it. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kathie" wrote in message ... 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, . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
| Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
| Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
| how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Linear Mode
