Feedback by UserVoice

Michael Daughety

My feedback

  1. 8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Michael Daughety commented  · 

    I wrote vba functions for this years ago. This should be considered, especially since the code wasn't too difficult.

  2. 10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Michael Daughety supported this idea  · 
  3. 159 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Michael Daughety supported this idea  · 
  4. 94 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Michael Daughety commented  · 

    Here is a VBA Function that I wrote that is pretty clean:

    Public Function CleanString(ByVal strSource As String, ByVal strCharToClean As String) As String
    Dim arrRemove() As String
    Dim strOut As String
    Dim iChar1 As Long
    Dim iChar2 As Long

    ReDim arrRemove(Len(strCharToClean))

    For iChar1 = 0 To UBound(arrRemove)
    arrRemove(iChar1) = Mid(strCharToClean, iChar1 + 1, 1)
    Next
    arrRemove(UBound(arrRemove)) = Chr(34)
    For iChar1 = 1 To Len(strSource)
    bFound = False
    For iChar2 = LBound(arrRemove) To UBound(arrRemove)
    If Mid(strSource, iChar1, 1) = arrRemove(iChar2) Then
    bFound = True
    Exit For
    End If
    Next
    If Not bFound Then
    strOut = strOut & Mid(strSource, iChar1, 1)
    End If
    Next
    CleanString = strOut
    End Function

    Michael Daughety supported this idea  · 
  5. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Michael Daughety commented  · 

    Excel shouldn't auto format anything. If I want something formatted, I should tell Excel so. At the very least, give us a setting in File -> Options to change this feature.

    Michael Daughety supported this idea  · 
  6. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Michael Daughety commented  · 

    There is a worksheet function ISBLANK that returns true/false. Maybe you can modify your formula to use it and not depend on "" or 0 values.
    But despite that, I completely agree with your reques.

    Michael Daughety supported this idea  · 
  7. 451 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the suggestion Jessica. We’ve got a few other suggestions on the site that are similar with scientific notation, etc. We’ll take a look at this area, and pay special attention to any cases that get a lot of votes. So please keep the votes coming to help us do a good job at prioritizing asks like this!

    Cheers,
    John [MS XL]

    An error occurred while saving the comment
    Michael Daughety commented  · 

    This is true for cell values as well. Once it is turned to a date...well, all hope is lost. Best example:
    Formatted as a fraction A1 = 1/2
    B1 = A1*1 = 43832
    B1 should = 0.5
    Had to write this cumbersome formula to fix it when nothing else would:
    IFERROR(LEFT(C12,FIND("/",C12)-1)/RIGHT(C12,LEN(C12)-FIND("/",C12)),VALUE(C12))*$N$12

    Michael Daughety supported this idea  · 
  8. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Michael Daughety commented  · 

    I built a function for this and use it quite frequently. Please implement this function...pretty please...

    Michael Daughety supported this idea  · 
  9. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Michael Daughety commented  · 

    I ended up building a vba function for this.

    Michael Daughety supported this idea  · 
  10. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Michael Daughety supported this idea  · 
  11. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Michael Daughety commented  · 

    Right click on cell, select Date from Category. Select one of the date formats. Then click on 'Custom' Category. In the Type field enter, with out quotes:
    ddd, d mmm yyyy
    click ok. Your cell should be formatted the way you wanted.

  12. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Michael Daughety supported this idea  · 
  13. 14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Michael Daughety commented  · 

    I built a custom vba function for this for numbers up to 3000 digits. It was more a fun thing to do. The hard part is identifying all the names for numbers above quadrillion and so on. A lot of assumptions were made on my part. I can't imagine trying to do this in a hundred languages.

  14. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Michael Daughety supported this idea  · 
  15. 66 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Michael Daughety supported this idea  · 
  16. 48 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Michael Daughety supported this idea  · 
  17. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Michael Daughety supported this idea  · 
  18. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Michael Daughety supported this idea  · 
  19. 65 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Michael Daughety supported this idea  · 
  20. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Michael Daughety supported this idea  · 
← Previous 1

Feedback and Knowledge Base