698 reputation
1520
bio website simoneast.net
location Melbourne, Australia
age
visits member for 4 years, 9 months
seen yesterday

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
Aug
3
asked Formatting a comma-delimited CSV to force Excel to interpret value as a string
Aug
3
answered Opening CSV file in Excel corrupts telephone number column
Jul
21
comment How to set the default language in Notepad++
I tried that to add some more PHP file-types, but didn't seem to work. :-(