Excel Entry & Format Standardization

I have a collection of spreadsheets that contain a mix of text and numerical values. I need every record transferred into a single, well-structured Excel file and, while doing so, each field must follow a consistent format (dates in the same style, numbers with the same decimal places, text capitalisation unified, etc.).

Your work is essentially twofold: accurate data entry followed by format standardisation. No duplicate removal or error correction is required at this stage; the sole cleaning task is making sure every piece of information looks and behaves the same across the sheet.

Deliverable: a finished .xlsx file ready for immediate analysis, free of format inconsistencies.