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