86 reputation
2
bio website
location
age
visits member for 3 years, 5 months
seen Mar 21 at 10:42

Jun
17
comment Opening CSV file in Excel corrupts telephone number column
Are you looking for a solution for importing to Access, or Excel - or both? If you just want it to import into Access, do you experience any issues with the original csv, i.e. without opening in Excel?
Apr
30
comment What can cause an Excel status bar quick sum calculation to be wrong?
What are you trying to achieve? If it's using the status bar to confirm that the totals match something else, you could Ctrl+click the column headers to just calculate the visible columns. Alternatively, you can use the worksheet function SUBTOTAL which I believe will sum the visible cells. =SUBTOTAL(9,range)
Apr
20
answered Removing blanks from a column in Excel
Mar
26
comment What can cause an Excel status bar quick sum calculation to be wrong?
You've checked for hidden rows, are there any hidden columns?
Mar
26
answered How to stop VBA code from within excel converting Text to Time?
Mar
6
answered Sum if ONLY all the cells have a value?
Mar
6
answered Excel 2007 pivot table does not aggregate properly
Mar
6
awarded  Supporter
Feb
28
awarded  Teacher
Feb
25
answered select similar rows in excel 2011
Feb
25
answered Excel not properly recalculating values
Feb
13
answered Excel: convert text string to date/time format
Feb
5
comment How to convert 24/12/2010 7:24:56 AM into a time in Excel 2007?
Is your computer set to US date formats, and therefore expecting mm/dd/yyyy?
Feb
5
answered Time (over 4 days) versus data - how to make the graph in Excel
Feb
5
answered In Excel, copying cell *values* (not formulas)… yet keeping the cell formats