I am fed a Folder of 9 workbooks that I have to Consolidate
by Project and Employee in a single New Workbook, on Sheet1, same
Folder.
However the data to be summed by Employee has first to be Re-Formatted
from Text to Number with 2 decimals.
for example : 114.0000 H to 114.00 or 28.0000 Q to
28.00
Can you help me with these Loops & Format.
I am aware Excel 2007 has a Convert Text to Columns tool,
but I am using Excel 2005.
Thank you for your Help.
Celeste