Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I open an excel file correctly sent to me. After processing…

Customer Question
Hi.I open an excel file...
Hi.I open an excel file correctly sent to me.
After processing the worksheet, I save it. When opened again, the number values change to date format.How can I prevent the entire file from converting to the date format automatically?
Submitted: 1 year ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Answered in 7 minutes by:
8/2/2017
Programmer: Kamil Anwar, Computer Support Specialist replied 1 year ago
Kamil Anwar
Kamil Anwar, Computer Support Specialist
Category: Programming
Satisfied Customers: 7,074
Experience: 8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
Verified

Hello & Welcome to JustAnswer.

Thank you for your question. I will do my best to assist you.

May i connect with you remotely to troubleshoot the issue directly? Thanks

Ask Your Own Programming Question
Customer reply replied 1 year ago
ok
Customer reply replied 1 year ago
ok, lets do it
Customer reply replied 1 year ago
never mind. I'll get a refund.thanks anyway.
Programmer: Kamil Anwar, Computer Support Specialist replied 1 year ago

Sorry for inconvenience , do you still need help?

Ask Your Own Programming Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask ATLPROG Your Own Question
ATLPROG
ATLPROG
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7,677
7,677 Satisfied Customers
Experience: MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

ATLPROG 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:

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

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

848 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
Hi, I'm using Excel 2007 and I want to use a conditional
Hi, I'm using Excel 2007 and I want to use a conditional formatting for some cells. The conditions are in a different worksheet and with 2007 I'm not allowed to do this unless the conditions are named… read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
848 satisfied customers
I have pretty much no experience in writing macros in excel,
I have pretty much no experience in writing macros in excel, I'm hoping you might be able to help me. What I need to do is pull the information from the 'schedule' worksheet into the 'import' workshee… read more
amit.gzp786
amit.gzp786
96 satisfied customers
I noticed your response to another question regarding the users
I noticed your response to another question regarding the users inability to add columns to an Excel worksheet. so.... I use Excel 2003 and have been asked to work on a spreadsheet from more current v… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Hi John Im in need of yet another Macro. Its going
Hi John I'm in need of yet another Macro. It's going to be one workbook that - opens the highest dated csv file in a specific folder - manipulates the data then saves and closes - before closing it co… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have an cell is .csv number format, I would like to convert
I have an cell is .csv number format, I would like to convert into msf excel in text or number format. How should I do it? Currrently, when I display it in excel, it gave me the weird format. I can ch… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Mac Excel date format How do I set the date format to yyyy-mm-dd?
Mac Excel date format' How do I set the date format to yyyy-mm-dd? There is no option under "format cells-date" which replicates this. Have tried "Customise" and it does change it in the worksheet cel… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
how to update an excel cell once only when it equals a formula I have been using this
how to update an excel cell once only when it equals a formula I have been using this but when B1 equals a formula it doesn't work hope you can help Private Sub Worksheet_Change(ByVal Target As Range)… read more
J. Mar
J. Mar
IT Specialist
Master's Degree
341 satisfied customers
My current Excel 2007 worksheet cells all default to a Date/Time
My current Excel 2007 worksheet cells all default to a Date/Time format - how do I change this for an entire worksheet and new workbooks that I open?… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I cannot seem to maintain a date format on my mac when saving
I cannot seem to maintain a date format on my mac when saving a file as a tab delimited file. It should remain as yyyy-mm-dd, yet it always reverts to dd/mm/yyyy. Help?… read more
ehabtutor
ehabtutor
Computer Software Engineer
Bachelor's Degree
936 satisfied customers
I have an excel sheet setup like a calendar. I need to lock
I have an excel sheet setup like a calendar. I need to lock certain column cells from input being added if the date for that column is passed or -2 from the current date. I don't know much about prote… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have copied some employee hours worked information from the
I have copied some employee hours worked information from the internet and pasted it into an excel file. Then I'm using a VLOOKUP to find the employee name and grab the hours to use in a different wor… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I hav several applications that allow me to download an Excel
I hav several applications that allow me to download an "Excel" version of my data. Once I do this and open the file, it automatically opens up Excel and dumps the data into a regular worksheet. Probl… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have a .csv file created from Excel. In one of the fields
I have a .csv file created from Excel. In one of the fields the value is in scientific notation (for example 2.20511E+11) for each value. When I load the .csv file in Excel and highlight any of the va… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Excel problem I cannot insert a sheet column; When I try the
Excel problem: I cannot insert a sheet column; When I try the drop down "insert sheet column sheet" is dimmed. I can successfully insert and delete rows in this same worksheet/book. I've converted, mo… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I made a sheduling program using excel and used the countif
I made a sheduling program using excel and used the countif function to count the number of personnel yhat is working on a shift. I would like the entire (cells) in the range (column) to turn a color … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I need to update the price for a coresponding Code . The
I need to update the "price" for a coresponding "Code". The updated Price is in a spreadsheet among as many as 15,000 "Codes" in a column and the coresponding "Price" is in another column in the same … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Is there any way to imbed an Excel command (CUT, PASTE, INSERT)
Is there any way to imbed an Excel command (CUT, PASTE, INSERT) into a formula? A conditional statement will only return a value. I am trying to insert two rows into my spreadsheet if a certain condit… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
When I paste this 10-3101 into my excel spreadsheet it changes
When I paste this: 10-3101 into my excel spreadsheet it changes it to date Oct 31. The formatting doesn't seem right, set by default to custom. If I change the cell format to text, the text I pasted 1… read more
John D
John D
Bachelor Degree in Engineering
342 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