data entry not showing as entered

%3CLINGO-SUB%20id%3D%22lingo-sub-1523480%22%20slang%3D%22en-US%22%3Edata%20entry%20not%20showing%20as%20entered%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1523480%22%20slang%3D%22en-US%22%3E%3CP%3Ehelp!%26nbsp%3B%20an%20excel%20worksheet%20has%20suddenly%20started%20showing%20%23%20signs%20instead%20of%20actual%20numbers.%26nbsp%3B%20i've%20been%20doing%20this%20spreadsheet%20for%20over%20a%20year%20without%20a%20problem.%26nbsp%3B%20how%20can%20i%20fix%20it%3F%3C%2FP%3E%3CP%3Ethis%20is%20my%20problem%20on%20the%20June%20page%20of%20the%20worksheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1523480%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1524333%22%20slang%3D%22en-US%22%3ERe%3A%20data%20entry%20not%20showing%20as%20entered%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1524333%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F729334%22%20target%3D%22_blank%22%3E%40Dorothy83%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWiden%20the%20column.%20That's%20what%20happens%20when%20the%20number%20in%20question%20gets%20too%20wide%20to%20display.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20the%20problem%20isn't%20evident%20in%20any%20of%20the%20tabs%20when%20I%20open%20it.%20Nevertheless%2C%20that's%20the%20most%20likely%20cause%2C%20by%20far.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1524946%22%20slang%3D%22en-US%22%3EBetreff%3A%20data%20entry%20not%20showing%20as%20entered%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1524946%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F729334%22%20target%3D%22_blank%22%3E%40Dorothy83%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ENow%20it%20should%20be%20okay%20...%20see%20the%20inserted%20file.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EI%20set%20everything%20to%20100%25%20enlargement%20and%20adjusted%20the%20content%20of%20the%20cell%20size.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ESet%20zoom%20(bottom%20right)%20to%20100%25%2C%20you%20can%20change%20it%20there.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vergr%C3%B6ssern.JPG%22%20style%3D%22width%3A%20359px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F205594i38E1E8B7F5DBDED1%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vergr%C3%B6ssern.JPG%22%20alt%3D%22Excel%20Zoom%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EExcel%20Zoom%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIf%20that's%20not%20what%20you're%20looking%20for%2C%20just%20ignore%20it.%3C%2FSPAN%3E%20%3CSPAN%3EBut%20if%20that's%20what%20you're%20looking%20for%2C%20I'd%20be%20happy%20to%20find%20out%20if%20I%20could%20help%20you%20with%20a%20thumbs%20up%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EP.S.%20%3CSPAN%20class%3D%22%22%3EBut%20what%20John%20Alsdorf%20wrote%20is%20the%20cause%20and%20is%20absolutely%20right%20...%20I%20only%20added%20a%20small%20solution%20of%20many%20possible%20ones%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

help!  an excel worksheet has suddenly started showing # signs instead of actual numbers.  i've been doing this spreadsheet for over a year without a problem.  how can i fix it?

this is my problem on the June page of the worksheet.

2 Replies
Highlighted

@Dorothy83 

 

Widen the column. That's what happens when the number in question gets too wide to display.

 

But the problem isn't evident in any of the tabs when I open it. Nevertheless, that's the most likely cause, by far.

Highlighted

@Dorothy83 

Now it should be okay ... see the inserted file. I set everything to 100% enlargement and adjusted the content of the cell size.
Set zoom (bottom right) to 100%, you can change it there.
Excel ZoomExcel Zoom

 

If that's not what you're looking for, just ignore it. But if that's what you're looking for, I'd be happy to find out if I could help you with a thumbs up

 

P.S. But what John Alsdorf wrote is the cause and is absolutely right ... I only added a small solution of many possible ones

 

Nikolino

I know I don't know anything (Socrates)

 

 

Nikolino

I know I don't know anything (Socrates)