Reputation
5,957
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 15 36
Newest
 Yearling
Impact
~1.6m people reached

Mar
21
revised Excel CSV import treating quoted strings of numbers as numeric values, not strings
added advantage
Mar
21
revised convert a table of 3 columns of {x, y, value} to the matrix table
minor change, explained parts of formula
Mar
21
answered convert a table of 3 columns of {x, y, value} to the matrix table
Mar
20
answered Excel 2010 - VLookup, Search and Match are doing things beyond my imagination
Mar
20
reviewed Leave Open How to stream video and music over LAN?
Mar
19
revised change link cell formula across sheets
reverted filename
Mar
19
comment Excel CSV import treating quoted strings of numbers as numeric values, not strings
There is another way, but I don't know if it's possible in your case: have the web app export to comma-delimited .TXT instead of .CSV (or just change the file extension of the exported file). This sort of "forces" users to go through the import wizard when they open the file.
Mar
19
answered Excel CSV import treating quoted strings of numbers as numeric values, not strings
Mar
19
revised change link cell formula across sheets
reformatted for clarity
Mar
19
comment Data appears different after opening .xls file through a macro
I can't seem to duplicate this problem. What XL version are you running? Do dates and times appear different too?
Mar
19
revised Data appears different after opening .xls file through a macro
changed title, clarified problem in body, minor changes in spelling
Mar
19
revised How is OFFSET supposed to work on filtered EXCEL data?
added 661 characters in body
Mar
19
answered How is OFFSET supposed to work on filtered EXCEL data?
Mar
18
comment How do I split a number into decimal and fractionary in Excel?
+1 But there seems to be problem with negative numbers though. =MOD(-8.74, 1) returns 0.26. Changing the 2nd argument to -1 (at least when dealing with negative values) should be able to fix it.
Mar
18
answered Convert one column into multiple rows
Mar
18
revised Ms Excel Formulas for Date and Day
retagged
Mar
18
reviewed Close Clearing app install history in Windows 8
Mar
18
reviewed Leave Open How to store passwords
Mar
18
reviewed Close file association batch file windows 8
Mar
18
reviewed Leave Open Hard drive fell to the floor