5,512 reputation
21134
bio website
location
age 25
visits member for 3 years, 8 months
seen Oct 27 at 5:50

Web/print designer with an affinity for coffee, bubblewrap and Pokemon.

I don't fancy myself an academic nor an Excel guru. I just happen to really like Excel and use it for virtually almost anything.

Oh and I'm exactly 0.955224 smoots tall.


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
Mar
18
reviewed Leave Open Run command on non-duplicated files
Mar
18
reviewed Leave Open Are there functional differences between USB ports on a motherboard?
Mar
18
reviewed Close How to select memory for motherboard when building a new machine?
Mar
18
reviewed Close Are monitor drivers necessary?
Mar
18
reviewed Close On Windows 7 Mutiple Wallpaper Scenario: How would I get the filename of the currently-displayed Wallpaper?
Mar
18
revised How can I get rid of empty rows in my spreadsheet?
added 19 characters in body