Unwanted hyphen appears in calculated cell

[TechByter]

I have created a small spreadsheet with three columns: % completion, count down from 67, and date. The first column uses =(67-B3)/67 formatted as % to display the progress to a future date. Excel has added a hyphen-like character at the left edge of every calculated cell EXCEPT the first calculated cell. This doesn't affect the usability, but the the extra visual junk is an annoyance and I haven't been able to figure out how to eliminate it. If you've seen this and know how to fix it, please let me know.
Thanks!

 

[Alex Blakenburg]

In this case the objects were not obviously objects and too small to select directly. In normal circumstances the quickest way to select all objects is in fact to select one of the objects on the spreadsheet and hit Ctrl+A.
The advantage of using the Objects Selection Pane was that it identifies object types in this case being "Ink".

Coincidentally the F5 / GoTo method was covered in this weeks Allen Wyatt's Excel Tips Newsletter

Get Rid of Web Stuff

When you copy information from a Web page and paste it into a worksheet, you can end up with more than you bargained for. Here's how to get rid of the extraneous objects that may end up in the worksheet.

excelribbon.tips.net

On having done some testing, the GoTo method will always pick up "all" objects while the Select then Ctrl+A methods will not pick up Active X objects unless you first turn on Design mode in the Developer tab.