$$Excel-Macros$$ Re: Formatting Output of Numbers for Printing to File

I typed your numbers into a sheet and it automatically formatted as you have displayed. I checked the format, right clicked into cell and picked "Format Cells", then "Number" and checked the format and it was formatted simply as "Decimal Places:" = to 2. Thanks, David On Saturday, February 24,

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 2 updates in 2 topics

Can you specify the number of decimal places you want? Or does that change and if so can you specify the conditions that will give specific decimal places? Thanks, David On Sat, Feb 24, 2018 at 3:32 PM, wrote: > excel-macros@googlegroups.com >

$$Excel-Macros$$ Re: How to paste trendline equation from graph into a cell

Marek, The trendline equation is in a DataLabel object and you can get access to that text and insert it in a cell. So a quick and dirty way to do this is: Private Sub Test() ActiveSheet.ChartObjects("Chart 1").Activate Cells(1, 1) = ActiveChart.FullSeriesCollection(1).Trendlines(

$$Excel-Macros$$ Formatting Output of Numbers for Printing to File

Hi all, This may be an easy one and I'm just not understanding formatting... I have calculations which give numbers like: 0.03799 9.89619 4.90005 0.01899 0.34994 I'll be printing (or writing) data to a file using vba But the numbers I want are: 0.038 9.9 4.9 0.019 0.35 Is