answersLogoWhite

0


Best Answer

Apply formatting to the cell that you want. There does not have to be anything in the cell when you apply the formatting. Then when you type a date in, it will show in the format you want.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do to keep Excel from changing the form of the date put in?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

When does super Mario galaxy 2 come out?

It comes out in Australia February 10 2010. that's a 90% posibble chance. People keep changing the date.


Can you import data from the web to excel?

There are lots of ways of doing it and some websites give you special ways to do it so as to keep dynamic data up to date, such as changing share prices. It really depends on what it is you are trying to import and where it is coming from.


When does season 7 of One Tree Hill come out on DVD in new zealand as they keep changing the release date?

May 4, 2011


Advantages software can Excel be integrated with Word?

Excel and Word can be integrated. You can have some of the spreadsheet appear as a table in Word. If you set a link between them, then when Excel updates, so will the Word document. Word does have the facilities to do its own calcuations in tables, but they are limited and so Excel is better. So if you want the figures in a Word document and to keep them up to date as they change in the Excel document, then a link is the way to do it. You would copy the data you want in Excel, and then do a Paste Link in the Word document.


What is the price of Sony Ericson Satio in GBP?

About £400 but the prices keep changing form day to day so watch out!


What is the difference between recyclable and renewable?

Recyclable - can keep being used without changing the essential form. Renewable - keeps its same form without being recycled.


Why does your computer keep changing the screen resolution in vista?

Answering "Why does your computer keep changing the screen resolution in vista?"


What is used when you want to keep others from changing the worksheet?

use when you want to keep others from changing the worksheet (password)


Why did they keep changing their mind?

That depends who you mean by "they"; also, what they are changing their mind about.


Can a collection agency keep changing the date last updated to keep a delinquent account on your credit report?

Legally they are not allowed alter the dates but there is very little regulation on this. It is very important that you keep the creditors in line and make sure that they are reporting the information properly.


Why do the olympics keep changing?

fairness


How long is it safe to keep any form of tablets?

It depends on individual tablets and when it was produced. Check the label and it will show the expiry date