653 reputation
112136
bio website n/a
location Napier, New Zealand
age 38
visits member for 3 years, 5 months
seen Nov 16 at 20:11

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

Currently interested in new work opportunities!


Feb
8
revised How to prevent Excel rounding numbers or adding redundant 0's?
cleaned up
Feb
8
accepted How to prevent Excel rounding numbers or adding redundant 0's?
Feb
8
comment How to prevent Excel rounding numbers or adding redundant 0's?
Thanks, @Raystafarian, that works nicely! This wasn't the only answer that worked, and after some thought I decided I prefer the other one (as it converts the data format to be text), but this one is perfect for anyone happy (or wanting) to retain a numeric data format. Hopefully some upvotes will bring it to 2nd place...
Feb
8
comment How to prevent Excel rounding numbers or adding redundant 0's?
Thanks, @barry-houdini, great answer! That works nicely.
Feb
7
comment How to prevent Excel rounding numbers or adding redundant 0's?
Excel 2007.....
Feb
7
comment How to prevent Excel rounding numbers or adding redundant 0's?
If I do that for the entire column, I get redundant 0's on the end of other values that only have 5DP's
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 approved 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!