fix an error #VALUE1 in formula with absolute referencing

%3CLINGO-SUB%20id%3D%22lingo-sub-2499269%22%20slang%3D%22en-US%22%3Efix%20an%20error%20%23VALUE1%20in%20formula%20with%20absolute%20referencing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2499269%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20m%20trying%20to%20use%20a%20formula%20containing%26nbsp%3B%20absolute%20referencing%20but%20i%20keep%20getting%20error%20message%20%23VALUE!.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2499269%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2499442%22%20slang%3D%22en-US%22%3ERe%3A%20fix%20an%20error%20%23VALUE1%20in%20formula%20with%20absolute%20referencing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2499442%22%20slang%3D%22en-US%22%3EHi!%20You%20need%20to%20change%20your%20O%2FT%202%20Hours%20from%20dashes%20to%20zeros%2C%20excel%20is%20reading%20that%20as%20text%20and%20can't%20do%20math%20as%20text.%20If%20you%20change%20that%20you'll%20be%20good%20to%20go!%3C%2FLINGO-BODY%3E
Occasional Visitor

i m trying to use a formula containing  absolute referencing but i keep getting error message #VALUE!.

1 Reply
Hi! You need to change your O/T 2 Hours from dashes to zeros, excel is reading that as text and can't do math as text. If you change that you'll be good to go!