Somebody already referenced F# elsewhere in the thread: https://docs.microsoft.com/en-us/dotnet/fsharp/language-refe.... It will apply unit of measure checks as part of their static type checking.

Beyond simply joining in on the F# love... If you're using Python anyway, then Pint¹ makes unit handling really easy.

¹ https://pint.readthedocs.io/en/stable/tutorial.html

In python there’s the pint module, which works with pandas dataframes, which can read/write excel sheets. So yeah, maybe. Why do anything in excel, except for data entry?