Tuesday, November 6, 2012

yogi_Spell Out An Amount Say Currency Such As Dollar And Cents As Would Be On A Check


                                           Google Spreadsheet   Post  #853
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 06, 2012
user alexg5 said : (http://productforums.google.com/forum/?zx=xdgf04nj8c5p#!category-topic/docs/spreadsheets/29-KGBPC74U)


UPDATE ... formula presented in this blog post
does not work in Google New Sheets
so
see the following blog post for formula in Google New Sheets
yogi_Spell Out An Amount Say Currency Such As Dollar And Cents As Would Be On A Check -- For Google New Sheets

Spelling (out an amount say currency such as dollar and cents) amounts in Google Spreadsheets
I am trying to print out company checks using Google Docs. I want everything to be very easy and plug and play.

Is it at all possible to have Google Docs spell out a dollar amount as it would be on a check?
For example turn $36.95 to "Thirty six dollars and ninety five cents"

I have it working on Excel as a macro, but can't figure out how to do it with Google Docs.

Thanks!

-------------------------------------------------------------------------------------------
following is a solution to the problem

5 comments:

  1. Thanks for the response! How do I actually use that formula to convert the number to text?

    How do I call it?

    ReplyDelete
  2. Hi Alex:

    The solution I have provided is formula based ... so let us say you key-in 36.95 in cell A2, then copy the formula in my blog to cell B2 -- the formula will result in thirty six dollars and ninety five cents.

    This is an array formula, so you can type a number of amounts in column A, starting with row 2 down, and the single formula in cell B2 will spell out the amounts in corresponding rays of column B.

    See the illustration in my blog post.

    I hope this helps.

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete
  3. Hi Alex:

    I have added an on-line calculator to convert an amount into dollar and cents in the following blog post:

    http://yogi--anand-consulting.blogspot.com/2012/11/yogion-line-calculator-to-spell-out.html

    for this one you an do the conversion on-line without having to copy my formula to your spreadsheet.

    Check it out to see how this works for you.

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete
  4. Got it! I should have noticed the A6 in the formula.

    Thank you!!

    ReplyDelete
  5. You Are Very Welcome Alex ... Now Let Us keep Googling.

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete