WednesdayC
Board Regular
- Joined
- Nov 7, 2010
- Messages
- 201
- Office Version
- 2016
- Platform
- MacOS
Hi All
Please can someone help me. I am assigning a range to an array. The numbers (column 7) are all formatted to 2 decimal places, but when the numbers were written to the array, the numbers were coming through at 1, 2 or more decimal places, with whole numbers, not displaying any decimal places. I have managed to capture decimal numbers to 2 decimal places in the array, by capturing the result to a variable (probably not the best way to do this), formatting the variable and then adding to the array, but the whole numbers are staying as whole numbers, no matter what I try!
Any help, as always would be much appreciated, as I am really stuck.
Regards
Wednesday
Please can someone help me. I am assigning a range to an array. The numbers (column 7) are all formatted to 2 decimal places, but when the numbers were written to the array, the numbers were coming through at 1, 2 or more decimal places, with whole numbers, not displaying any decimal places. I have managed to capture decimal numbers to 2 decimal places in the array, by capturing the result to a variable (probably not the best way to do this), formatting the variable and then adding to the array, but the whole numbers are staying as whole numbers, no matter what I try!
Any help, as always would be much appreciated, as I am really stuck.
Regards
Wednesday