excel 2010 with wierd square

Microsoft Microsoft windows server 2008...
September 17, 2012 at 00:29:49
Specs: Windows xp
hi
my excel is acting up, currency values in cells have a weird square looking separator. when i enter a for example 10 000 000, this is how it displays: 10,000[]000 (couldnt find a solid square). i tried looking for any anormalies at the regional options but everything seems normal. please assist so that my values display with commas eg 10,000,000. thank you

See More: excel 2010 with wierd square

Report •


#1
September 17, 2012 at 06:05:18
Try changing the font used in Excel.

Report •

#2
September 17, 2012 at 06:27:00
Is it only the second comma in a large number?
What happens If you have only one comma in a number?

What version of Excel are you running?

If your running 2007 or 2010 try a Diagnostic:

To run a Diagnostic::

Running Microsoft Office Diagnostics from within Excel / Word

Click the Microsoft Office button
Click on the Excel / Word Options button to bring up the Options dialog box (at the bottom of window)
Click on the Resources button in the left hand pane
Click on the Diagnose button in the right hand pane
Click Continue
Click Run Diagnostics

Running Microsoft Office Diagnostics from the Start Menu

Click on the Start button
Click All Programs
Click Microsoft Office folder
Click Microsoft Office Tools
Click Microsoft Office Diagnostics
Click Continue
Click Run Diagnostics

You could also check your Editing Option:

Click the Microsoft Office button
Click on the Excel / Word Options button to bring up the Options dialog box (at the bottom of window)
Click Advanced button in the left hand pane

Under Editing Options, make sure you have the "Use System Separators"
box checked.

MIKE

http://www.skeptic.com/


Report •

#3
September 18, 2012 at 23:07:25
my excel 2010 does not have the office button, onlyy the excel button where the offiece button is supposed to be, on the top left corner. the same applies for all my office programs.

Report •

Related Solutions

#4
September 18, 2012 at 23:19:50
apparently office 2010 does not have the office button, was replaced by the file button, i looked around for the same options you indicated above and couldnt find them

Report •

#5
September 19, 2012 at 06:38:26
Try doing a Repair:

In Control Panel
Open Programs and Features
Select Microsoft Office, do not double Click on it, simply select it.
At the top of the window you should see the selection Change
Click on Change
then select Repair.

You may need your original install media.


MIKE

http://www.skeptic.com/


Report •

#6
September 23, 2012 at 23:26:12
tried repair, same problem persists

Report •

#7
September 24, 2012 at 05:27:09
Is it only the second comma in a large number?
What happens If you have only one comma in a number?

Have you checked Custom Formatting,
perhaps there is a rouge format floating around.

Also, you could check AutoCorrect and see if something in there is the problem.

MIKE

http://www.skeptic.com/


Report •


Ask Question