I was trying to export a report which is in float format. When I do that, all the numbers in excel have a green small tag beside it saying
"The number in this cell is formatted as text or preceded by an apostrophe".
I have to sum my report values and this can only be done after I convert each cell to number. Is there any possible way to handle this in report itself?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!