208 reputation
27
bio website
location Australia
age
visits member for 1 year, 4 months
seen Mar 28 at 9:19

Mechanical and Manufacturing Engineer by trade.

Work a lot with SSRS, Report Builder, Oracle, VBA, Excel, SharePoint.


Jul
28
awarded  Yearling
Feb
25
awarded  Notable Question
Nov
19
awarded  Popular Question
Jun
21
awarded  Teacher
May
14
answered excel how to replace using wildcard character
May
14
comment excel how to replace using wildcard character
Not with standard functionality. Is vba an option?
May
5
comment Suppress now printing dialog - Microsoft VBS
I think APIs are your only hope ad the print dialog is an internal function. See access.mvps.org/access/api/api0037.htm for use.
May
5
comment Suppress now printing dialog - Microsoft VBS
So you have another macro that is run? Can you share that or a portion also?
May
2
awarded  Editor
May
2
revised Include an OR condition in a COUNTIF?
table formatting
May
2
suggested suggested edit on Include an OR condition in a COUNTIF?
Apr
30
answered Check if Excel cell text is numeric using formula only
Apr
30
awarded  Scholar
Apr
30
awarded  Student
Apr
30
comment Check if Excel cell text is numeric using formula only
@brettdj thanks for that! For an answer that uses the least number of charaters and is quick and dirty I've now got =N(-A1). Didn't know that existed either.
Apr
30
comment Check if Excel cell text is numeric using formula only
+1. As a quick and dirty I like =VALUE(A1) as my data won't have the need for CLEAN(). I didn't know the VALUE() function existed. Just to note the TRIM() does nothing as spaces are ignored anyway.
Apr
30
accepted Check if Excel cell text is numeric using formula only
Apr
30
comment Check if Excel cell text is numeric using formula only
Also I've found out that you dont even need to use trim. My regards.
Apr
30
comment Check if Excel cell text is numeric using formula only
+1 for speed and a good anwser. It sucks when things are right in your face but you can't see them!
Apr
30
asked Check if Excel cell text is numeric using formula only