573 reputation
92035
bio website n/a
location Napier, New Zealand
age 38
visits member for 2 years, 11 months
seen Jul 8 at 1:21

Database driven web application programmer, with interests in regular expressions, Bitcoin, sustainability, and ethics.


Feb
7
comment How to prevent Excel rounding numbers or adding redundant 0's?
I think you're onto what I want to do, except of course saying I can't do it doesn't really help a lot! In my case, I don't input the data myself, however extracting it and putting it back in might be a valid option.
Feb
7
comment How to prevent Excel rounding numbers or adding redundant 0's?
See my comment on Raystafarian's answer.
Feb
7
comment How to prevent Excel rounding numbers or adding redundant 0's?
This would be fine if all the numbers had the same amount of decimal places (or if I was happy with redundant 0's on the end). Unfortunately, that's not the case. I essentially want the numbers treated like text and displayed exactly as they are stored.
Feb
7
revised How to prevent Excel rounding numbers or adding redundant 0's?
added clarification
Feb
7
asked How to prevent Excel rounding numbers or adding redundant 0's?
Jan
31
revised How do I create a safe system on a used computer (running Windows 7) once purchased?
grammar correction
Jan
30
revised Is there a way to use Conditional Formatting on a row based on values in a single column?
clarified grammar
Jan
30
suggested suggested edit on Is there a way to use Conditional Formatting on a row based on values in a single column?
Jan
30
comment How do I create a safe system on a used computer (running Windows 7) once purchased?
I don't think that's the case for OEM licenses. All the literature I can find says the only place I can get a reinstall disc for an OEM version is from the manufacturer who built the PC.
Jan
30
comment How do I create a safe system on a used computer (running Windows 7) once purchased?
Reworded, hoping that it addresses the problem the downvoters had with the question!
Jan
30
revised How do I create a safe system on a used computer (running Windows 7) once purchased?
reworded to avoid "best practice"
Jan
30
comment How do I create a safe system on a used computer (running Windows 7) once purchased?
Are the downvotes because I'm asking for best practice? Would it be better to ask for what the official Microsoft best practice is (which should have an exact answer)? Feedback please!
Jan
30
asked How do I create a safe system on a used computer (running Windows 7) once purchased?
Jan
19
comment How to boot from DVD when BIOS doesn't seem to give the option to change the boot source?
Bingo! It seemed to be the case that by the time I saw the "BIOS <F2>" message, it was too late - hitting F2 earlier (but not too early) seemed to do the trick. That got me into the BIOS. It's a bit irritating that the same key also starts the Windows Boot Manager (as it confuses things), but I guess different PCs probably have different BIOS entry keys. Thanks very much for your wisdom!
Jan
19
accepted How to boot from DVD when BIOS doesn't seem to give the option to change the boot source?
Jan
19
comment How to boot from DVD when BIOS doesn't seem to give the option to change the boot source?
Will investigate if I run out of other options. This is a desktop PC though.
Jan
19
revised How to boot from DVD when BIOS doesn't seem to give the option to change the boot source?
<f2> wasn't displaying
Jan
19
comment How to boot from DVD when BIOS doesn't seem to give the option to change the boot source?
@opsin, not yet. I'll try those and report back. The brand on the box is Ipex. I will open it up shortly and make notes of the hardware. I will come back to you with the DVD model too. Thanks!
Jan
19
comment How to boot from DVD when BIOS doesn't seem to give the option to change the boot source?
I've been in quite a number of BIOS screens before, and "Windows Boot Manager" certainly didn't look like any of them. Strangely though, it's what comes up when I hit F2 when I see the "<F2> BIOS" note at the bottoms of the screen. I will try hitting it earlier, and report back.
Jan
19
asked How to boot from DVD when BIOS doesn't seem to give the option to change the boot source?