Excel Formatting & Formula Checkup
Publicada el 2026-07-16
Descripción de la oferta
I have a working Excel file that needs a quick but thorough polish. First, every date currently appears in a mix of US, ISO, and text strings; I need them all converted so they display—and calculate—as DD/MM/YYYY across the entire workbook. While you’re in there, please audit the existing formulas. A few cells are returning #VALUE! and I suspect some references have turned into hard-coded numbers. Deliverables: • Workbook returned with every date formatted to DD/MM/YYYY, verified with a spot-check that underlying serial values remain intact. • All formulas tested; any broken, circular, or hard-coded references corrected or clearly commented. • Brief change log (one sheet or text file) outlining what was fixed and any recommendations for future maintenance. I use the latest Microsoft 365, so feel free to leverage Power Query or other native tools if it speeds the task. Let me know your estimated turnaround and any clarifying questions—once confirmed, I’ll send the file right away.
Skills
Fuente original: freelancer