User Profile
Don_Pepe
Copper Contributor
Joined May 12, 2023
User Widgets
Recent Discussions
Re: #VALUE disappears when I delete a random cell or line
Hi NikolinoDE, Thanks for your help, I found the issue. DATEVAL and TEMPSVAL (DATEVALUE & TIMEVALUE in en) induce regional formating error in Excel online. I just remove them and now everything is ok. Thanks again for your help, Don1.3KViews0likes0CommentsRe: #VALUE disappears when I delete a random cell or line
NikolinoDE, Thanks for your help, I cheked these thing and everything were ok. If I recalculate, I still have the error but if I copy the formula then delete the formula then past the formula in the same cell, the error desappears. FYI, the formula is (in french sorry): =DATEVAL(GAUCHE(TEXTE(AX$4-1;"jj/mm/aaaa") &" "& TEXTE($B6;"hh:mm:ss");10))+TEMPSVAL(DROITE(TEXTE(AX$4-1;"jj/mm/aaaa") &" "& TEXTE($B6;"hh:mm:ss");8)) Best, Don1.3KViews0likes2Comments#VALUE disappears when I delete a random cell or line
Hi, Sometimes when I open my file, it's full of "#VALUE" and nothing seems wrong. I tried to recalculate and recalculate manually but doesn't work. I found out that if I delete a random cell or line or column, all these #VALUE disappears. Do you know what's the issue ? Or similar case ? Best, DonSolved1.5KViews0likes4Comments
Recent Blog Articles
No content to show