As an example, you might have a list of product costs and want to increase the values to add a profit ... in Sales by Percent for the Number of Years in Excel How to Calculate the Decline in ...

Instead, Excel removes the automatically applied date format, leaving the date’s serial value. At this point, you can’t even convert the entry to text because the value is now a number.