Triming number of decimal places thoughout whole Workbook into same cell.

Hello and thank you for any help.

I have a large workbook that I receive from one of our suppliers each month for reporting with all the percentage cells set as raw numbers like "95.55". I am unable to convert the cells to percentages as it then makes it 9555.00%, and as this is used in a number of linked tables in a number of documents I can not simply add a new colum to deal with this, and I would like to reduce the amount of work required to prep the data.

Workbook contains 20+ worksheets, each worksheet contains a table of data from A6 to F36. E6 to E36 holds a percentage displayed as "100.00000000" (Excel thankfully already trims the zeros at the end of this) or "99.12345678" and I would like to clean it up over the whole workbook to a simple 2 points "99.12".

I dont care about rounding or anything else, as this is being used for reporting and not calculation, but position of the cells is important.

This might be as simple as a find and replace with special characters, or it might require a macro, sadly my excel knowledge is limited (Why cant Vim open Excel files )

Thanks,
Wofen

Originally Posted by protonLeah

One way:
In an unused cell, enter 0.01, and copy the cell
Select E6:E36 and select Paste Special, Multiply...
Format as %

Thanks for the reply, but that would require me to change the data on each worksheet.

I was hoping that I could use the find and replace with ??.???????? to ??.?? but that just replaces the number with 4 question marks.

Does excel have pattern mataching, or allow find and replace with formats?

Thanks,
Wofen