Excel Online Displays Incorrect Cell Format

%3CLINGO-SUB%20id%3D%22lingo-sub-2060668%22%20slang%3D%22en-US%22%3EExcel%20Online%20Displays%20Incorrect%20Cell%20Format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2060668%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20Online%20file%20will%20not%20display%20cell%20data%20in%20correct%20format.%20Adjusting%20the%20column%20width%20temporarily%20fixes%20the%20problem%2C%20which%20is%20unusual.%20Has%20anyone%20ran%20into%20this%20problem%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIncorrect%20display%20below.%20Columns%20R%20and%20V%20are%20in%20Date%20formats%2C%20while%20S%20and%20W%20are%20on%20Time%20formats.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22VARGAR1_0-1610628984843.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246388iF455115F53A5F9AB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22VARGAR1_0-1610628984843.png%22%20alt%3D%22VARGAR1_0-1610628984843.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomehow%2C%20adjusting%20column%20widths%20accurately%20displays%20values%2C%20but%20only%20for%20a%20minute%20or%20two.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22VARGAR1_1-1610629064504.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246389i8E0363778D345D43%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22VARGAR1_1-1610629064504.png%22%20alt%3D%22VARGAR1_1-1610629064504.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advice%20on%20how%20to%20fix%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2060668%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

Excel Online file will not display cell data in correct format. Adjusting the column width temporarily fixes the problem, which is unusual. Has anyone ran into this problem? 

 

Incorrect display below. Columns R and V are in Date formats, while S and W are on Time formats.

VARGAR1_0-1610628984843.png

 

Somehow, adjusting column widths accurately displays values, but only for a minute or two.

VARGAR1_1-1610629064504.png

 

Any advice on how to fix this? 

 

0 Replies