secny1

Up until recently I could upload excel spreadsheets that I have created with formulas and import them and update them as need be. I would format the cells to currency or number etc. All of a sudden the formatting isnt staying when I upload if I have formatted a cell as number with 2 decimal places (ie 324.85). Once uploaded the number when imported may change to 324.8536 I can find no place in Caspio for an answer to this,or anyway to format to TWO (2) decimal places in the table view, and I have been doing this for 3 years without an issue. I need 2 decimal places only. Why does it seem like the importing is ignoring my formatting now, and using the formula calculation. I have over 8500 entries in 4 or 5 spreadsheets and had to manually change them all in the table view window! I dont want to that that every week! Thank you