How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9654
Experience:  Worked on Macs and PC's for 20+ years.
Type Your Mac Question Here...
John D is online now
A new question is answered every 9 seconds

I need a formula that I can enter into a google spread sheet

Resolved Question:

I need a formula that I can enter into a google spread sheet cell that will print text of a number in another cell. Example cell b25 has number 132. I to enter a formula in d25 that will say One hundred thirty two and 00/xx
Submitted: 2 years ago.
Category: Mac
Expert:  John D replied 2 years ago.

Hi,

 

There are readly available macro samples on the web that can do that. But it is much more difficult to do it with a formula.

 

 

Customer: replied 2 years ago.
It is not a Mac question. It is a spread sheet question. I want to enter a number in a cell, then I want that number to print in words like on a check in another designated cell.

132.00 in a cell

the formula I need will be put into another cell and the words One hundred thirty two and 00/xx will appear. My nunbers will not exceed 99 million
Expert:  John D replied 2 years ago.

No macro is not "Mac". It means using code instead of formulas

 

 

Customer: replied 2 years ago.
I need need to use it in a google spread sheet. I there is any way to do it, that is what I want to know.

I have never used a macro in a spread sheet.
Customer: replied 2 years ago.
Where are we now?
Customer: replied 2 years ago.
I will pay $60.00
Expert:  John D replied 2 years ago.

Ok give me about 30 mins to write the formulas on an excel file, but you will need to upload it yourself to Google Docs

 

Customer: replied 2 years ago.
No problem
Expert:  John D replied 2 years ago.

Ok here is a test file for your review

 

http://www.2shared.com/document/8FWNZuIm/Book1.html

 

(make sure to click the blue DOWNLOAD button at the bottom of the download page)

 

Try it by entering different values in cell A7 to see how it works. If it is ok I will send you the full version

 

 

John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9654
Experience: Worked on Macs and PC's for 20+ years.
John D and 6 other Mac Specialists are ready to help you
Expert:  John D replied 2 years ago.

Thanks. Ok you can pay the balance using the Add Bonus button while I prepare the final version

 

Expert:  John D replied 2 years ago.

Ok I have the final version ready now.... Let me know if you cannot find the bonus button

 

 

 

Expert:  John D replied 2 years ago.

Thanks.

 

Here is the file. The final formula in B7. The auxiliary formulas are in helper columns C thru V which you can keep hidden if you like

 

You can copy the formulas down to as many rows as you like, but make sure you also copy the formulas in columns C thru V

 

http://www.2shared.com/document/Ctna_BO_/Book1a.html

 

(make sure to click the blue DOWNLOAD button at the bottom of the download page)

 

Let me know if you have any questions

 

Thanks again

 

Customer: replied 2 years ago.
How do I move the formula around. Like putting the number at m12 and the words at b15
Expert:  John D replied 2 years ago.

Just drag cell A7 and drop it in M12, and drag B7 and drop it in B15

 

 

Customer: replied 2 years ago.
Need dumb question how do I get to those rows?
Expert:  John D replied 2 years ago.

How do you get to which rows? All rows and columns are accessible and you can get to any of them

 

 

Customer: replied 2 years ago.
row "C" thru "V" do do appear on the spreaqd sheet
It goes A B W
Expert:  John D replied 2 years ago.

Do you mean "columns" not "rows", right?

 

I still don't understand what you are saying. If you want to make use of columns A thru V, you can shift the entire set of formulas to the right of column W. Just select column A, and keep inserting columns until the number field gets shifted to column W, and with it all the other formulas will be shifted

 

Customer: replied 2 years ago.
Thank you. I am good and it works perfetually. I will now put it on google docs and should be good, but that is for tomorrow.
Expert:  John D replied 2 years ago.

Great. Glad I was able to help

 

 

Customer: replied 2 years ago.
Now that we have it. I need to have a possibility of up to 6 cases or the formula to have six different number and the words printed in six different places.


c12 = the number
d12 = words

c15 = number
d15 = words

etc.
Expert:  John D replied 2 years ago.

Please send me your new file so I can try to set it up for you

 

 

Customer: replied 2 years ago.
The spread sheet you sent was perfect for one numbers to words sequence. I need six different numberson the same sheet tat go to words just like the one you have made. I am bidding on construction jobs and their may be six totals that have numeric bids that have to show in words also. Each of these total comes from other sheets with multiple item that the owner never sees.

Example
base bid________(we put in number) base bid in words_______words print

Alternate 1_______________ alt 1 in words___________________

Alt 2 ______________ Alt 2 in words_________________________

Bond____________________ bond in words___________________

Total bid__________________ total bid in words_____________________

Expert:  John D replied 2 years ago.

No I need the actual Excel file

 

 

Customer: replied 2 years ago.
Can you telephone me at XXX-XXX-XXXX

Western Alta Construction

or how do I attach the file or I can share a google file we have used.
Expert:  John D replied 2 years ago.

I am afraid we are not allowed to make phone calls on this site. You can use the paperclip icon on the toolbar.

 

 

 

 

 

 

 

 

Customer: replied 2 years ago.
I replied to the email and attached the file a while ago. I do not know how to attach a file from here as there is no paper clip. I can easily share the sheet on google docs if I have an email address
Expert:  John D replied 2 years ago.

We cannot use email either

 

Please go to http://www.wikisend.com/ and upload the file (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.

 

If the file has sensitive information let me know before you upload it

 

 

Customer: replied 2 years ago.
168470 file id link. Tab GC's is confidntial
Expert:  John D replied 2 years ago.

I got the file.

 

Please list the cells in that file that have the numbers which need to be converted along with the cells where the corresponding words should appear

 

Customer: replied 2 years ago.
Every bid sheet is different. Some have one one price other have more. We have to make our spreed sheet match their form and then print on their form.
Expert:  John D replied 2 years ago.

So what do you want me to do then?

 

Please just give me the cells that need to be converted on one sheet. I see hundreds of numbers in different rows and columns and I have no idea which is which

 

 

Customer: replied 2 years ago.
The subs tab is formatted to print on their form. First the sublist itself and them the prices at the bottom which are brought over from the general tab. In this case the cells were d43 d48 and 50 but on the next bid it will be different cells.
Expert:  John D replied 2 years ago.

So I am not quite sure what I need to do with this file unless you tell me exactly what you want.

 

I think this question is getting quite extended (this is about the 25th message since I sent you the file with the formulas). Perhaps you should consider opening a new tickets

 

Expert:  John D replied 2 years ago.

Those cells that you mentioned (i.e. cells d43 d48 and 50) on which sheet are they on?

 

Customer: replied 2 years ago.
The subs tab. Third one over
Expert:  John D replied 2 years ago.

On that sheet there are no values in cells d43 d48 and 50. I will I assume that you meant D42, D44, D49 and D51.

 

Will set up the formulas on these cells and get back to you

 

 

 

 

 

Expert:  John D replied 2 years ago.

Ok let me know when you're back online so I can send you the file

 

 

 

 

John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9654
Experience: Worked on Macs and PC's for 20+ years.
John D and 6 other Mac Specialists are ready to help you
Customer: replied 2 years ago.
I am back on or XXXXXXXX@XXXXXX.XXX
Expert:  John D replied 2 years ago.

Ok one moment...

 

 

Expert:  John D replied 2 years ago.

Ok here you go

 

http://www.2shared.com/document/Bnir1LmD/Commerce_City_Hall_Library_1.html

 

(make sure to click the blue DOWNLOAD button at the bottom of the download page)

 

Hope this helps

 

 

 

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
< Last | Next >
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
  • The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you! Frank Canada
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
 
 
 

Meet The Experts:

 
 
 
  • Mike

    Mac Medic

    Satisfied Customers:

    6256
    Over 20 years IT experience with Apple computers in publishing, marketing and design.
< Last | Next >
  • http://ww2.justanswer.com/uploads/macthelife/2009-10-20_1899_mikesebaharsquare64.jpg Mike's Avatar

    Mike

    Mac Medic

    Satisfied Customers:

    6256
    Over 20 years IT experience with Apple computers in publishing, marketing and design.
  • http://ww2.justanswer.com/uploads/AS/ashiknasameen/2012-5-15_141836_final2.64x64.jpg Ashik's Avatar

    Ashik

    Mac Helper

    Satisfied Customers:

    5282
    7+ Years of Experience in troubleshooting Macs, iPhone, iPad, iPod etc
  • http://ww2.justanswer.com/uploads/DP/dpean/2012-6-6_172828_avatorme1.64x64.JPG Daniel's Avatar

    Daniel

    Mac Genius

    Satisfied Customers:

    4670
    Apple certified on desktop and portable, help desk qualified. Have owned and used Macs since 1989.
  • http://ww2.justanswer.com/uploads/VI/vinodvmenon2005/1.64x64.jpg Vinod Menon's Avatar

    Vinod Menon

    Support Specialist

    Satisfied Customers:

    2068
    worked as a Tech support Associate for Apple products
  • http://ww2.justanswer.com/uploads/BE/beboo/2011-1-14_201648_n5063313142021801763.64x64.jpg Brandon M.'s Avatar

    Brandon M.

    Mac Support Specialist

    Satisfied Customers:

    1501
    10+ Years Mac Support as contractor and currently an IT Manager for law firm
  • http://ww2.justanswer.com/uploads/MA/MacDruid/IMG_0232.64x64.JPG John T. F.'s Avatar

    John T. F.

    Mac Druid

    Satisfied Customers:

    1408
    20+ years in the computer/Mac industry
  • http://ww2.justanswer.com/uploads/MA/MacHelpdesk/1d2d506.64x64.jpg David's Avatar

    David

    Mac Support Specialist

    Satisfied Customers:

    1236
    BSc, H.Dip, Apple Certified