I'm pretty decent with Excel, but all of a sudden, I have weird squares in place of where the decimal points used to be. Anybody have this before? What can I do? The rest of the numbers in the cell are unaffected. This happened to all of my Excel documents. Is this a virus with my font?
It looks like:
67@889
812@45
3@90
@ = square
2006-06-22 19:15:00 · 5 answers · asked by Hungry707 3 in Computers & Internet ➔ Software
Actually I never changed my font....it is still Arial and the columns are definitely big enough to display the value. It's weird - this happened to all of my Excel documents at the same time!
2006-06-22 19:27:39 · update #1
It would be interesting to know if the square behaves like a decimal point - that would mean the following would be likely to solve the problem...
This is for W2K, XP may be slightly different..
Start - Settings - Control Panel - Regional options - Numbers
The entry against "Decimal Symbol" should be a . but I suspect you'll find a square here. Change it to a dot, then click apply.
If it's not a square, change it to something else, then back to a dot, then click apply.
Hope this works. I was just able to replicate your symptoms on my PC this way, so I'm feeling lucky.
2006-06-23 08:23:08 · answer #1 · answered by Anonymous · 2⤊ 0⤋
Your decimal point was not a real dot, instead it was possibly some symbol from a different font/character set. And for some reason excel is unable to show that symbol. May be the version of excel is different, or you switched computers. The file was created on a computer with a certain version but you may be using a different computer/different version... there are many possibilities. But I don't think it is a virus, just the way excel handles special characters.
2006-06-22 19:21:10 · answer #2 · answered by The_Dark_Knight 4 · 0⤊ 0⤋
Try changing the font back to something boring like Arial.
Later:
OK, copy the square (which sounds like the default character office often uses when it can't find a character in a particular font), pull down the edit menu to "replace", paste the square into the "find" field, and type a decimal point in the "replace" field. What happens?
2006-06-22 19:18:46 · answer #3 · answered by Beckee 7 · 0⤊ 0⤋
The answer is quite simple. The weird squares appear when there is not enough room in the cell to display the total data contained within the cell. at the top RH corner of the column simply increase the width of the column by clicking and dragging the right side of the column (at the top in the gray area) to the right and release button and all data should be displayed
2006-06-22 19:22:49 · answer #4 · answered by Anthony E 1 · 0⤊ 0⤋
Which font are you utilising? Open note and note in case you get the sq. block with an same font. i comprehend Excel and that i don’t see any incorrect way you are able to replace a comma right into a field. Do you've custom upload-ons, or are you utilising seen undemanding? I don’t have journey with those and they might introduce your blunders. It sounds more effective like between the above than an outbreak. Viruses tend to be a great deal crueler and do more effective nasty issues than change a field for a comma. you need to be operating an Anti Virus software. if so then that ought to capture ninety 5% of the viruses that are despatched your way. maximum viruses are practice through “script kitties” who take products of different viruses and shrink and paste them jointly and that i have never heard of an outbreak that makes any such minor replace to a software. I did look on the help Wizard, even if it didn’t help me a lot. in case you come across a treatment on your difficulty drop me a line, please.
2016-11-15 03:51:48 · answer #5 · answered by Anonymous · 0⤊ 0⤋