I want the result is 0.23%, not 0.0023, in fact just want 0.23, because the same column data some entry is 0.23%, and some people directly recorded 0.23, there are thousands of files, each file has thousands of data, so can't use the method of * 100, hope you can use a python program out directly, and then remove the percent
CodePudding user response:
Alternatively, excel cell set format for text, not a percentage