Forum Discussion
opabato
Dec 12, 2024Copper Contributor
Getting #VALUE! error in Excel
Excel was working perfectly fine yesterday. However, when I logged into my PC this morning and opened the Excel sheet I was working on, I simply copied and pasted the formula from above. After adjust...
HansVogelaar
Dec 15, 2024MVP
Thank you for sending the workbook by PM.
If you set the horizontal alignment of columns C and D to General, you'll see that almost all times are right-aligned except for C76. That value is left-aligned, indicating that Excel sees it as a text value.
Select C76, press F2 then Enter. The value should now be right-aligned and the formula in E76 works: