In many of my forms, I select the option to have new rows added to the top so they are easy to find. When I do this, however, I find that most of the time, the data does not keep the numerical formatting I've applied to the column previously. This makes automated purchase order approvals come through without the $, and when it defaults to tenths instead of hundredths it causes problems for my payroll team who have to pay to the 1/4 hour. How can I ensure new data takes on the format I want? Interesting point - the color format is kept, but not numerical format.
In the example below, the Total Cost field is a calculated field from the columns on the right (which are pulled in from a separate sheet using Index/Match function). As you can see, my newest entries from the form are not showing currency format.
Similarly, when my late call hours come in from supervisors, I only see one decimal place, but the payroll must calculate to .25 or .75 of an hour so I need to capture that for their export.
Any help is appreciated as this is only 2 of many examples. ~Stacey
