When I have a date field, or a text field with numerals included, and then
drag that field down a range of cells, Excel increments the date or the
numeral within the text. How do I copy a field down a range, leaving it
unchanged, by dragging the value without incrementing the date or numeral
within text?

Thanks
Bill