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 matthewgill Your Own Question

matthewgill
matthewgill, Computer Scientist
Category: Computer
Satisfied Customers: 17
Experience:  I have a BS in Computer Science, an MS in Integrated Science & Technology, as well as prior military experience.
74898053
Type Your Computer Question Here...
matthewgill is online now
A new question is answered every 9 seconds

Excel Question;I need someone to answer multiple questions.The

Resolved Question:

Excel Question;

I need someone to answer multiple questions.
The first questions;
I need to have someone create a Custom Format that;

Create a Microsoft Excel Custom Cell Format that changes with the size/length of the number ie (1=1.000, 10=10.00, 100=100.0, 1000=1000)
Submitted: 1 year ago.
Category: Computer
Expert:  matthewgill replied 1 year ago.
Try formatting the cells using the custom-defined "#.000"

This will get you the appropriate decimal place, but will put three zeros behind all values.

Next, click on Data Validation which is located under the Data/Data Tools tab. Select Text length from the allow drop down box, and then select equal to under the data drop down box. Finally set the maximum to 4.
Customer: replied 1 year ago.

Matt


 


I believe i followed your directions correctly.


 


However when i enter a number I get the ERROR:


 


"The value you entered is not valid,


A user has restricted values that can be entered into this cell?


 


i just put the number 12 in and got this message.


 


Any more information to solve this?


 


I have an estimating program i am working on and i enter quantity numbers from .123 to 9999.


 


Any other ideas?


 


Thanks Gary


 

Expert:  matthewgill replied 1 year ago.
Gary, sorry that this didn't solve your problem. Before you restrict the length of the cells, what output are you getting?
Customer: replied 1 year ago.

It won't let me NOT enter a number in the length feild


Are you getting it to work on your excel?


 


 

Expert:  matthewgill replied 1 year ago.
Gary, I'm getting mine to work, but I may be misunderstanding something you are asking.

http://www.extendoffice.com/documents/excel/952-excel-cell-character-limit.html

follow this link, and try and reproduce the first example. It may be necessary to remove the '#.000' formatting.
Customer: replied 1 year ago.

OK... so what are the instructions to create this format?


 


Thank you


 


gary

Expert:  matthewgill replied 1 year ago.
If the #.000 formatting isn't working, then try and have the formatter set it up automatically.

http://office.microsoft.com/en-us/excel-help/change-the-decimal-places-displayed-for-numbers-HP001216499.aspx

Do this before you limit the length. Also, you may have to limit the length to 5 instead of 4, because the decimal point may count as a character
Customer: replied 1 year ago.

 


OK... I think i got it. Originally i wanted the same number of characters in the fields.


 


But... i can live with this.


 


How are you at macros?

Expert:  matthewgill replied 1 year ago.

Gary, glad you got it! I've never attempted Macros. Excel isn't my strong suite, and I use it when I have to, but not much more. Is it something specific? I may be able to knock it out for you.

 

Macros are based around a record-and-run setup. Simply press record, do the macro, then stop recording, and payback

Expert:  matthewgill replied 1 year ago.
Here is a video:

http://www.dummies.com/how-to/content/how-to-record-a-macro-in-excel-2007.html
Expert:  matthewgill replied 1 year ago.
Gary, just checking in. If you require further assistance, please let me know.
Customer: replied 1 year ago.

Matt


 


Yes... i was satisfied with your response.


 


I have several Excel Macro or VBA solutions that i need answers too.


 


Are you good a Macros and VBA solutions? Or do you know someone who is?


 


And how do i get you paid?


 


Thanks


 


Gary

Expert:  matthewgill replied 1 year ago.
Gary, I really appreciate working with you, but unfortunately I am not the best with Macros. I don't really use them, and wouldn't feel confident in giving you advice. I recommend that you repost the question with a more specific title. Something like "Need help with Excel 2007 Macros."

As far as getting paid and closing this particular question, all I request is that if you found my responses to be satisfactory then please leave me a positive rating. It may also show up as "Rate My Question".

I will look around and see if there are other experts that would be better suited to your new question; however, I am new here and don't know many others.

Thank you again, you have been fantastic to work with!
matthewgill, Computer Scientist
Category: Computer
Satisfied Customers: 17
Experience: I have a BS in Computer Science, an MS in Integrated Science & Technology, as well as prior military experience.
matthewgill and 13 other Computer Specialists are ready to help you

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:

 
 
 
  • 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
< Last | Next >
  • 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
  • I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you! RP Austin, TX
  • 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
  • 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
 
 
 

Meet The Experts:

 
 
 
  • Andy

    Computer Consultant

    Satisfied Customers:

    5311
    11yr exp, Comp Engg, Internet expert, Web developer, SEO
< Last | Next >
  • http://ww2.justanswer.com/uploads/EN/Engineer1010/2012-6-9_132423_jaj12a.64x64.jpg Andy's Avatar

    Andy

    Computer Consultant

    Satisfied Customers:

    5311
    11yr exp, Comp Engg, Internet expert, Web developer, SEO
  • http://ww2.justanswer.com/uploads/BA/barrenrock/2011-10-19_215925_JamesJAFinal.64x64.jpg James's Avatar

    James

    Sr. Computer Support Expert

    Satisfied Customers:

    8376
    20 years of experience building, fixing and servicing PCs and operating systems.
  • http://ww2.justanswer.com/uploads/zeyank/2009-09-26_154244_P8110079.png Ryan H.'s Avatar

    Ryan H.

    Computer Support Specialist

    Satisfied Customers:

    1741
    A+ Certified Technician - 10 Years experience working with all types of computer systems.
  • http://ww2.justanswer.com/uploads/JA/jadedangel57/2011-11-8_193134_janenewsm.64x64.jpg Jane Lefler's Avatar

    Jane Lefler

    Sr Prog Analyst / Technician

    Satisfied Customers:

    0
    Computer Programmer / Technician/ Consultant 16+ years
  • http://ww2.justanswer.com/uploads/RO/robmpreston/2013-9-23_233814_mijiFZm.64x64.jpg RPI Solutions's Avatar

    RPI Solutions

    Support Specialist

    Satisfied Customers:

    3476
    5+ Years in IT, BS in Computer Science
  • http://ww2.justanswer.com/uploads/BA/barunrath/2012-7-5_201954_Profilepic2.64x64.jpg B. Rath's Avatar

    B. Rath

    Computer Support Specialist

    Satisfied Customers:

    8671
    Certified Computer/Networking Support Specialist.
  • http://ww2.justanswer.com/uploads/FS/fszcze/2012-6-18_181848_500test.64x64.jpg Frederick S.'s Avatar

    Frederick S.

    Computer Specialist

    Satisfied Customers:

    7240
    Computer technician and founder of a home PC repair company.