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

2018-03-05 Thread sourav devrani
You can use this. Application.WorksheetFunction.RoundUp(VarArray(LngR, 1), 2) On Sun, Feb 25, 2018 at 5:51 AM, who wrote: > 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 "

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

2018-02-24 Thread who
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,