Computing desk
< July 22	<< Jun \| July \| Aug >>	July 24 >

Welcome to the Wikipedia Computing Reference Desk Archives
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.

July 23

Excel 2010

I'm building a spreadsheet and I need to keep adding "0805", which because it has a leading zero displays as "805", so I'm entering it as "'0805", the leading tick works fine.

However Excel now keeps telling me that "The number in this cell is formatted as text or is preceded by an apostrophe". I know that. To get rid of the obnoxious hovering diamond, I have to click it and select "Ignore Error" - every time.

Is there a way to turn this (and this sort of) feature off? Indeed, I'd like to turn 99% of Excel and Word "auto-help" functions off, can it be done? You spend more time fixing the auto-help than you do creating the document! -- SGBailey (talk) 08:12, 23 July 2013 (UTC)[reply]

Why not format the cells with a Custom Format of 0000? --Phil Holmes (talk) 08:56, 23 July 2013 (UTC)[reply]

(edit conflict) See here for how you can turn off the error checking. You are able to selectively turn off checking for different errors, so in your case you can deselect 'numbers formatted as text or preceded by an apostrophe', or just turn off the whole caboodle. - Cucumber Mike (talk) 08:57, 23 July 2013 (UTC)[reply]

Great. Thanks CM. -- SGBailey (talk) 10:03, 23 July 2013 (UTC)[reply]

June 22: How to download map too large for xapi

I didn't know it was possible to add card from openstreemap to a GPS using SDXC.

I want to chose a custom area and get city explorer functionalities.

I am trying to download base map in osm format for converting it and this HTTP request doesn't work: http://api.openstreetmap.fr/xapi?*[key=value][bbox=-70,12,62,84]. 2A02:8422:1191:6E00:56E6:FCFF:FEDB:2BBA (talk) 19:23, 23 July 2013 (UTC)[reply]

For some decent pointers, see OSM wiki-page on Garmin devices. Personally I tend to get my updated maps from openstreetmap.nl, which has instructions for installations here. WegianWarrior (talk) 20:33, 23 July 2013 (UTC)[reply]

The problem is not I can't transfer and convert map to my GPS. It is that I want to chose a custom region and I can't download it to .osm xml (see xapi hyperlink on precedent post).

Update: OpenStreetMap.nl doesn't work : "Selected map is too large!" 2A02:8422:1191:6E00:56E6:FCFF:FEDB:2BBA (talk) 21:22, 23 July 2013 (UTC)[reply]

Hyperlink times out for me (bad gateway). Try looking at the OSM Map on Garmin page at the OSM Wiki, which has instructions on how to create your own img-files for your Garmin. - including links to software that can apparently make the job easier. WegianWarrior (talk) 03:46, 24 July 2013 (UTC)[reply]

I understood the instructions given. I know how i can convert .osm files. The problem is they don't explain how to download a quarter of the planet in Openstreetmap format (I want to choose my own area). 2A02:8422:1191:6E00:56E6:FCFF:FEDB:2BBA (talk) 11:29, 24 July 2013 (UTC)[reply]

Best suggestion I can offer then is to ask on the OSM wiki. WegianWarrior (talk) 17:01, 24 July 2013 (UTC)[reply]

PC doenst show image. Time to change video card?

I have a pc at home that have a video card (motherboard doenst have intagrated video card), when I turn it on the monitor shows nothing and the power on of the monitor blinks.
But the pc really turns on, I am able to access some of his files by network if I turn it on and I am able to see his network enabled printer. I also tested the monitor with my notebook and it works
Tried to remove the video card, and put it back to see if this would work, but this doenst worked
Video card fan, is working.
PS: I was using the pc at night and on the next day, this problem happened.
With the pc really turning it on, and the monitor really working, the only fix is to buy a new video card?
201.78.161.229 (talk) 23:27, 23 July 2013 (UTC)[reply]

Try plugging a different monitor into your PC. If that one doesn't work, then it's surely a failed video card and you will have to replace it. --Yellow1996 (talk) 01:08, 24 July 2013 (UTC)[reply]

Not sure it can be the video card i've seen something similar: the video card didn't look to work. The Problem was caused by the AGP controller. It was a single chip on the motherboard and it was that thing which didn't worked anymore. If it is a similar case changing the screen don't mean it would be the video card. The best way to check if a component don't work is to replace it with an another one known for working. 2A02:8422:1191:6E00:56E6:FCFF:FEDB:2BBA (talk) 12:21, 24 July 2013 (UTC)[reply]

Yes, if you can get a different card for the slot, you can test if that one works. If it does, your video card is obviously the culprit.

And you can try if your video cards works in a different slot (that is, if your mobo has at least two compatible slots). I had some cheap PCI ethernet i/f cards which kept failing in one make of motherboard. Pulling them and putting them into a different PCI slot always fixed the prob -- somehow the mobo refused to "talk" to the card any more.

No bulls - that was the way it worked! - ¡Ouch! (^{hurt me} / _{more pain}) 16:20, 27 July 2013 (UTC)[reply]