Cannot Fill A Value From Cell Above

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3140811%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ECannot%20Fill%20A%20Value%20From%20Cell%20Above%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3140811%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%20Guys%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI'm%20still%20new%20to%20the%20excel%20and%20I'm%20trying%20to%20do%20my%20work%20here%20and%20I%20have%20to%20fill%20in%20the%20blank%20cell%20with%20the%20value%20above%20it%20(as%20you%20can%20see%20in%20the%2039th%20row).%20I%20tried%20everything%20but%20it%20seems%20everything%20doesn't%20work.%20Can%20someone%20help%20me%20out%3F%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThank%20you%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346494i78FFE050AF9F08B4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Screen%20Shot%202022-02-09%20at%209.33.20%20AM.png%22%20shot%3D%22%22%202022-02-09%3D%22%22%20at%3D%22%22%209.33.20%3D%22%22%20am.png%3D%22%22%20alt%3D%22Screen%20Shot%202022-02-09%20at%209.33.20%20AM.png%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3140811%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

Hi Guys,

 

I'm still new to the excel and I'm trying to do my work here and I have to fill in the blank cell with the value above it (as you can see in the 39th row). I tried everything but it seems everything doesn't work. Can someone help me out? 

 

Thank you

Screen Shot 2022-02-09 at 9.33.20 AM.png

1 Reply
I Think its because of number format .
Change the number format to general and try .