Hello,
I wonder if someone has a solution for me. I am using the following function to calculate the number of days a workorder has been open.
=DAYS360(H3:H5752,TODAY())
I would like to prefill the function for 5000 rows. I am getting this 5 digit number (38191) when I copy and paste the formula to prefill the 5000 rows. Is there a way to hide the 5 digit number or format it to "0"? I have tried the format function, but I can't seem to find the right format to use.
Thanks.
I wonder if someone has a solution for me. I am using the following function to calculate the number of days a workorder has been open.
=DAYS360(H3:H5752,TODAY())
I would like to prefill the function for 5000 rows. I am getting this 5 digit number (38191) when I copy and paste the formula to prefill the 5000 rows. Is there a way to hide the 5 digit number or format it to "0"? I have tried the format function, but I can't seem to find the right format to use.
Thanks.