Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate multiple workbooks (...and adding new files in the masterworkbook on the fly) | Excel Discussion (Misc queries) | |||
Consolidate Multiple Workbooks - Excel 2007 | Excel Worksheet Functions | |||
Consolidate multiple workbooks into a single worksheet | Excel Worksheet Functions | |||
How to consolidate workbooks automatically from multiple emails? | Excel Programming | |||
Consolidate multiple workbooks | Excel Worksheet Functions |