Re-Format from Text to Number & Consolidate multiple Workbooks
 

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

Re-Format from Text to Number & Consolidate multiple Workbooks
 

Excel 2003 has Text-to-Columns in the Data menu on the worksheet menu. this
will only put long strings into different cells. the VAL function may do
what you want. Try this code. Modify the rows and columns to match your
data.


For ColCount = Range("A1").Column To Range("D1").Column
For RowCount = 3 To 10
Cells(RowCount, ColCount) = Val(Cells(RowCount, ColCount))
Next RowCount
Next ColCount

"u473" wrote:

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