732 reputation
1521
bio website simoneast.net
location Melbourne, Australia
age
visits member for 4 years, 11 months
seen Dec 17 at 23:46

Nov
17
comment What determines the quality of a video
Bjorn, I think izx is probably right. Bits per pixel is probably the closest thing you'll get to an accurate comparison between videos. I believe videos encoded at the same quality will have a similar BPF even if they have different framerates and resolutions, even though their total bitrate will be completely different.
Sep
19
answered notepad++ highlight colours
Sep
14
awarded  Popular Question
Jul
12
awarded  Popular Question
Apr
23
awarded  Popular Question
Mar
15
awarded  Revival
Jan
8
awarded  Yearling
Dec
15
awarded  Self-Learner
Nov
17
comment How to completely disable the Windows 7 taskbar?
Ah! My mistake. Totally correct, Ctrl+Shift+ESC.
Nov
16
comment How to completely disable the Windows 7 taskbar?
Yep, this works great for deploying applications in "kiosk-mode". But you still have access to the task manager (Ctrl+Esc) for launching other apps or shutting down the PC.
Aug
8
accepted What is the Flash Player performance bottleneck? Not CPU?
Aug
8
accepted How can I open Outlook Calendar to a 2-3 week view by default?
Aug
8
comment Formatting a comma-delimited CSV to force Excel to interpret value as a string
it's a PHP script that exports a database table. CSV is probably the easiest to work with, but you're correct, I could probably produce an XLS with the help of some open-source code, or even just an HTML table which I think from past experience produces reasonable results in Excel (allows colours & formatting etc., but not sure about data-types).
Aug
8
accepted Formatting a comma-delimited CSV to force Excel to interpret value as a string
Aug
8
revised Formatting a comma-delimited CSV to force Excel to interpret value as a string
Clarified the intent of my question
Aug
8
comment Formatting a comma-delimited CSV to force Excel to interpret value as a string
@PriceChild, the point of my original question (that I didn't really explain very well) was actually how to format the CSV to make it as easy as possible for users. And so this is the answer I found myself and wanted to post. DMA57361 actually brought a helpful correction too, thanks!
Aug
8
comment Formatting a comma-delimited CSV to force Excel to interpret value as a string
Excellent answer DMA57361, thanks for all the detail. What I didn't really mention in my question was that I'm writing a script that exports data to Excel, so I was trying to prevent users from having to jump through confusing options like this. But voted you up anyway. :-)
Aug
8
revised Formatting a comma-delimited CSV to force Excel to interpret value as a string
Added corrections based on comments, thanks guys!
Aug
3
answered Excel 2007 is converting CSV fields into formulas
Aug
3
answered Formatting a comma-delimited CSV to force Excel to interpret value as a string