Mac

Ask Mac Questions and Get Answers from Experts ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Mac
This answer was rated:

I am trying to build a spread sheet to organize my taxes (expenses

and income). I am...
I am trying to build a spread sheet to organize my taxes (expenses and income). I am a long-term HP used but now have a MAC and I am struggling with format. Can you recommend a tutorial for me?
Show More
Show Less
Ask Your Own Mac Question
Answered in 3 minutes by:
2/5/2011
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,

 

What is not holding? and what are you trying to do when you right click on a cell?

 

Are you able to type formulas in the cells?

 

Ask Your Own Mac Question
Customer reply replied 6 years ago
When I try to format a cell for text or number it does not always hold that format.
If I want to put in a date such as 1-5 ( leaving out the 2011 because my header includes the year: 2011 so I don't need to enter it. Also, How do I format the column to format to the right, left or center? The computer seems to want to add two numbers after the decimal even though I try to program it to omit the decimal.
I want to be able to omit $ signs if possible.

I see.

 

Ok to set the cells to show 1-5 for 1/5/2010, select that cell then go to Format > Cells, then click Custom from the Category list on the left pane, then type the following in the field on the right:

 

m-d

 

then click OK.

 

Now type a full date in that cell, i.e. 1/5/2010 and you will see the cell displaying 1-5

 

Try that and let me know so we can go to the next part of the question

 

 

 



Edited by John D on 2/5/2011 at 9:00 PM EST
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

Thanks.

 

Now with regard to the decimals,select the cells or columns that you want to format without decimals, then go to Format > Cells, then click Number from the Category list on the left pane, then type 0 in the 'Decimal places' field on the right. Click OK

 

Let me know if you still need help with this

 

 

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
It's regardind credit that's left on My account. I Pad Mini
Tried Apple Support they said to try yourselves I have 55cents in my account I am trying to remove as I live in Scotland … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,125 satisfied customers
Having problems with new chevrolet silverodo with car play.
having problems with new chevrolet silverodo with car play. They are going to try to solve next week. time times it works and other times not. Used various phones and cords … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,125 satisfied customers
I have a whole bunch of charges on my visa that say itunes.
Hi there, I have a whole bunch of charges on my visa that say itunes. I'm not sure why. I only use itunes gift cards as I never want to use my visa but I keep seeing itunes showing up on my visa despi… read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,125 satisfied customers
I don't have an apple device...I was charged for something
I don't have an apple device...I was charged for something on iTunes that I did not order and I have no idea how to protest charge since I don't have an iTunes account. … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,125 satisfied customers
I got a new ipod with the touch option and you also have to
I got a new ipod with the touch option and you also have to make a user name and password. Thought i made something, i didnt write it down and i kept trying until i got locked out. It says to try logg… read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,125 satisfied customers
I tried to watch golf videos but could not get audible to to
I tried to watch golf videos but could not get audible to to work … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,125 satisfied customers
How oo I contact google re my password for my Google account
how oo I contact google re my password ***** my Google account that I see on my cell phome. A inadvertly changed it on a different computer and it shows on my Apple cell phone. Thank You. … read more
Patrick Evans
Patrick Evans
Network Engineer
MS
10 satisfied customers
The batteries ran out on my wireless keyboard. Inserted new
The batteries ran out on my wireless keyboard. Inserted new ones. Now the computer cannot find the keyboard! Can you help please … read more
Kris R
Kris R
IT Manager
Computing
2,652 satisfied customers
I just checked my calendar and I have lost all of my
I just checked my calendar and I have lost all of my entries. That had happened before and I downloaded another calendar but I preferred the one that I had. Then one day everything appeared on my old calendar and I was thrilled. I have no skills as far as iPads are concerned, so I am at your mercy. Hope you can help. Dianne … read more
Vinod Menon
Vinod Menon
Support Specialist
Master's Degree
2,394 satisfied customers
Old password—[email protected] Correct
Old password—*****@******.***. Correct email—*****@******.*** … read more
Jon
Jon
Bachelors Degree
480 satisfied customers
Get message - Apple ID disabled - followed directions -
Get message - Apple ID disabled - followed directions - cannot correct … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,125 satisfied customers
In the past I have been able to upload all picture through
Hey, in the past I have been able to upload all picture through USB from iPhone to my lap top. Since I have been back from holidays, none of the "live" photos will transfer across to the computer … read more
Patrick Evans
Patrick Evans
Network Engineer
MS
10 satisfied customers
I'm in Mexico and want to reconfigure my sling box at home
I'm in Mexico and want to reconfigure my sling box at home via my ipad … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,125 satisfied customers
Apple is telling me that my email address and password are
Hi Apple is telling me that my email address and password ***** incorrect, I tried to set up a new apple ID without success … read more
RussellA
RussellA
Solutions Architect
Bachelor\u0027s Degree
123 satisfied customers
Can not log on. Last month. But not accepting it
Can not log on JA: When did you last change your password ***** Apple ID? Customer: Last month JA: Did you try resetting through Apple's online account reset tool? Customer: But not accepting it JA: A… read more
Karthik
Karthik
Senior Engineer
Bachelor of Engineering
70 satisfied customers
I am not able to update software it says your apple password
I am not able to update software it says your apple password ***** ***** … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,125 satisfied customers
Since I changed to High Sierra, Photos has become
Since I changed to High Sierra, Photos has become outrageously difficult to use. It is much slower and has accumulated delays that impede my workflow and waste valuable time. Is there any fix for this… read more
Kris R
Kris R
IT Manager
Computing
2,652 satisfied customers
My apple / iCloud password won't work. I typed in my old
I typed in my old password ***** it won't work since two weeks ago … read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,125 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