683 reputation
1519
bio website simoneast.net
location Melbourne, Australia
age
visits member for 4 years, 6 months
seen Jul 10 at 5:13

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. :-(
Jul
6
awarded  Yearling
Jun
13
comment Format a number with optional decimal places in Excel
If you need to avoid adding formulas (and probably a new column) to your spreadsheet then Fred's suggestion may be the best.
Jun
13
comment Format a number with optional decimal places in Excel
Why all the complicated INT(LOG... formula? Why not just ROUND(value,2) and format as General?
Jun
13
comment Format a number with optional decimal places in Excel
Yes, both TRUNC(x,2) and ROUND(x,2) will do the job (depending on what kind of rounding method you're after). You then just need to set the cell formatting to "General" and the decimal places will only be displayed if needed. (I vote to mark Droj's post as the answer.)