0
What will happen if the Fill Handle in Excel is used to drag from a cell containing date formatting?
Wiki User
∙ 9y ago
If there is a date in the cell, it will copied. If the cell is blank, but has date formatting, it will apply date formatting to all cells it is dragged to while also blanking out any content in those cells. If you then type a number into any of those cells, they will show as a date. Remember that dates start from the 1st of January 1900, so typing in a number will convert it to a date counting from that point. So, for example, if you typed in 5, it would put the date as the 5th of January 1900. If you typed in 10000 it will have the 18th of May 1927 as the date.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What is true about Excel checker?
Excel Checker is an Excel add-on that can find every occurrence of cells containing Data Validation or Conditional formatting and list them out on a separate sheet.
What Excel property help to design date in style?
Formatting. There are many ways of formatting dates in Excel.
True or False Excel interprets a cell containing the information on June 10 2011 as date and not as text?
That would depend on the formatting applied to that cell.
If the condition is true does Excel apply the formatting?
It will if you are asking about conditional formatting.
In addition to creating a series of values dragging the fill handle instructs Excel to the formate of a cell to range?
When you use the fill handle it will copy what is in the cell including the formatting.
Where are PivotTable formatting tools located in Excel?
When a pivot table is active, you can show its toolbar in older version of Excel and in the new versions the Pivot Table tools will be on the ribbon. Standard formatting, such as fonts, can be applied with the normal formatting options available in Excel.
How do I retain Excel cell formatting during mail merge into a table in Word?
Merge brings one to several individual cells from Excel into Word. The formatting in the merged Word document depends on Word, not Excel. If you would like to retain the same formatting as you had in Excel, then format the target location in Word to match the cell from Excel.
What best describes the result of using the fill handle on a cell containing a formula in Excel?
It is used to copy the formula down or across.
When using Excel 2010 making a change to the look of data is called what?
It is called formatting. A wide range of formatting options are available within Excel 2010.
What is conditional formatting with Highlight Cells Rules in Excel?
Conditional formatting can be used in Excel to implement certain rules or formulas. These can be done by using the Highlight Cells Rule whereby only the highlighted cells will receive the formatting.
Does Excel have two types of conditional formatting?
You do Conditional Formatting based on a cell value or based on a formula.
May be used to apply formats if certain conditions exist in excel?
Conditional Formatting.
