Mac

Ask Mac Questions and Get Answers from Experts ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Mac

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

Customer Question
cell that will print text...
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: 6 years ago.Category: Mac
Show More
Show Less
Ask Your Own Mac Question
Answered in 9 minutes by:
12/22/2011
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago
John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9,666
Experience: Worked on Macs and PC's for 20+ years.
Verified

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.

 

 

Ask Your Own Mac Question
Customer reply replied 6 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
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

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

 

 

Ask Your Own Mac Question
Customer reply replied 6 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 reply replied 6 years ago
Where are we now?
Customer reply replied 6 years ago
I will pay $60.00
Mac Support Specialist: John D, BS Degree in Engineering replied 6 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

 

Ask Your Own Mac Question
Customer reply replied 6 years ago
No problem
Mac Support Specialist: John D, BS Degree in Engineering replied 6 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
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9,666
Experience: Worked on Macs and PC's for 20+ years.
Verified
John D and 87 other Mac Specialists are ready to help you
Ask your own question now
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

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

 

Ask Your Own Mac Question
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

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

 

 

 

Ask Your Own Mac Question
Mac Support Specialist: John D, BS Degree in Engineering replied 6 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

 

Ask Your Own Mac Question
Customer reply replied 6 years ago
How do I move the formula around. Like putting the number at m12 and the words at b15
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

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

 

 

Ask Your Own Mac Question
Customer reply replied 6 years ago
Need dumb question how do I get to those rows?
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

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

 

 

Ask Your Own Mac Question
Customer reply replied 6 years ago
row "C" thru "V" do do appear on the spreaqd sheet
It goes A B W
Mac Support Specialist: John D, BS Degree in Engineering replied 6 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

 

Ask Your Own Mac Question
Customer reply replied 6 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.
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

Great. Glad I was able to help

 

 

Ask Your Own Mac Question
Customer reply replied 6 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.
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

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

 

 

Ask Your Own Mac Question
Customer reply replied 6 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_____________________

Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

No I need the actual Excel file

 

 

Ask Your Own Mac Question
Customer reply replied 6 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.
Mac Support Specialist: John D, BS Degree in Engineering replied 6 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.

 

 

 

 

 

 

 

 

Ask Your Own Mac Question
Customer reply replied 6 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
Mac Support Specialist: John D, BS Degree in Engineering replied 6 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

 

 

Ask Your Own Mac Question
Customer reply replied 6 years ago
168470 file id link. Tab GC's is confidntial
Mac Support Specialist: John D, BS Degree in Engineering replied 6 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

 

Ask Your Own Mac Question
Customer reply replied 6 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.
Mac Support Specialist: John D, BS Degree in Engineering replied 6 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

 

 

Ask Your Own Mac Question
Customer reply replied 6 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.
Mac Support Specialist: John D, BS Degree in Engineering replied 6 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

 

Ask Your Own Mac Question
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

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

 

Ask Your Own Mac Question
Customer reply replied 6 years ago
The subs tab. Third one over
Mac Support Specialist: John D, BS Degree in Engineering replied 6 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

 

 

 

 

 

Ask Your Own Mac Question
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

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

 

 

 

 

John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9,666
Experience: Worked on Macs and PC's for 20+ years.
Verified
John D and 87 other Mac Specialists are ready to help you
Ask your own question now
Customer reply replied 6 years ago
I am back on or [email protected]
Mac Support Specialist: John D, BS Degree in Engineering replied 6 years ago

Ok one moment...

 

 

Ask Your Own Mac Question
Mac Support Specialist: John D, BS Degree in Engineering replied 6 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

 

 

 

Ask Your Own Mac Question
Ask John D Your Own Question
John D
John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9,666
9,666 Satisfied Customers
Experience: Worked on Macs and PC's for 20+ years.

John D is online now

A new question is answered every 9 seconds

How JustAnswer works:

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

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

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!

FrankCanada

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 CustomerNew 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!!!!

AlexLos 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.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

< Previous | Next >

Meet the Experts:

Mike

Mike

Mac Medic

8,555 satisfied customers

Over 20 years IT experience with Apple computers in publishing, marketing and design.

Daniel

Daniel

Mac Genius

4,711 satisfied customers

Apple certified on desktop and portable, help desk qualified. Have owned and used Macs since 1989.

Vinod Menon

Vinod Menon

Support Specialist

2,394 satisfied customers

worked as a Tech support Associate for Apple products

John T. F.

John T. F.

Mac Druid

1,994 satisfied customers

20+ years in the computer/Mac industry

David

David

Mac Support Specialist

1,507 satisfied customers

BSc H.Dip Apple Certified Professional

Claws224

Claws224

IEEE Datacommunication Engineer

965 satisfied customers

IEEE, Microsoft

Mac Tech

Mac Tech

Apple Specialist

888 satisfied customers

7 + Years Supporting Apple Products

< Previous | Next >

Related Mac Questions
I have Microsoft office for apple (Mac). I deleted excel and
I have Microsoft office for apple (Mac). I deleted excel and power point, how do I get em back? … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I have an Excel workbook that opens extremely slow. What can
I have an Excel workbook that opens extremely slow. What can I do to speed it up? Thank you. … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,042 satisfied customers
I have a Mac with Microsoft ( word, powerpoint Excell and
I have a Mac with Microsoft ( word, powerpoint Excell and Outlook)I need to upgrade to outlook 2016. I am having problems as I don't remember my microsoft log in password Help … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I just purchased the excel-etal. I can't get excel to open.
I just purchased the excel-etal. I can't get excel to open … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,042 satisfied customers
I had to update my Word and Excel recently and I have had
I had to update my Word and Excel recently and I have had nothing but problems every since. I can't Save As two different Excel docs. I try to close them and I get a whirling wheel and "Refreshing" wh… read more
Josh
Josh
It Support Specialist
Associate Degree
5,138 satisfied customers
Microsoft office outlook and excel and word will not open, i
microsoft office outlook and excel and word will not open, i get the message this application will not open correctly with a code Oxc0000142. what must I do to correct ? … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,275 satisfied customers
I sent my wife and Excell file but we only have access to
I sent my wife and Excell file but we only have access to Mac computer so need to know how to convert it into pages to be able to open it on a MacBook pro … read more
Michelle
Michelle
Manager operations
Bachelor\u0027s Degree
1,275 satisfied customers
I have been using the microsoft one cloud/ excel and word
I have been using the microsoft one cloud/ excel and word apps on my apple Ipad. it is telling me (after two years use) that it can not connect with the internet. Meanwhile all my other apps can? … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,042 satisfied customers
Can I back out an upgrade to Excel without losing files? OS
Can I back out an upgrade to Excel without losing files? … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
I am trying to understand why the Mail merge from Excel to
I am trying to understand why the Mail merge from Excel to Word will not work on my brand new computer??? The excel is saved in the format ".xlsx" but it still says I need an Excel Workbook Text Cover… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,275 satisfied customers
I just this afternoon updated microsoft office excel but I
I just this afternoon updated microsoft office excel but I don't want it now. I have a backup external hard drive. can i get rid of the update by downloading from time machine. if so, how? … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,042 satisfied customers
I am trying to save updates to an excel spreadsheet on my
I am trying to save updates to an excel spreadsheet on my new 27" Mac that I brought in from a 10 year old Mac. I get a "something went wrong" massage, which recommended that I contact you. … read more
Cabletech
Cabletech
High School or GED
140 satisfied customers
I've used Excel for years with no problems. I have a new
I've used Excel for years with no problems. I have a new iMac desktop with a more current OS and Excel version than I have been using. … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,275 satisfied customers
I guess I need to update my Excel but not sure how to do it.
I guess I need to update my Excel but not sure how to do it … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,275 satisfied customers
Excel for Mac opens to a blank Excel file, When I bought the
When Excel opens to a blank file, it also freezes my machine from doing other things, such as logging out, restarting, etc. I've done a forced shutdown (holding down the power button), but this hasn't helped. Same problem exists once I restart the machine. … read more
Russell H.
Russell H.
computer technology consultant
Vocational, Technical or Trade Scho
781 satisfied customers
Im on my moms computer trying to help her. Her excel program
Im on my moms computer trying to help her. Her excel program is not working and will not open at all. I have the original Office.mac dvd but dont know how to reinstall excel without losing whatever da… read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
Hanging with Word and Excel - just did updates. No idea. It
It is a Mac mini, i7 with 16 mb ram purchased in 2013, it should be running the latest Mac OS … read more
Ashik
Ashik
Master\u0027s Degree
5,097 satisfied customers
Excel for Mac. The tabs at the bottom of the page have
Excel for Mac. The tabs at the bottom of the page have disappeared. Tried changing preferences as suggested and no change.Thanks.… read more
Jon
Jon
Bachelors Degree
479 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x