Example 6: Applying Data Formatting

Click in a cell to edit the data.
Click on the table headers to sort the rows.

Note that the format is applied to the raw data.
If this is a currency, the appropriate prefix (or suffix) will be added.
For dates, the proper date will be applied given a timestamp.
You can even use relative words like "today" or "1 week ago"! (Anything that strtotime() understands)

Edit Row Id Item Description Price Date Quantity Delete Row
1912 4 $4.00 December 26, 1969
1913 5 $6.00 December 31, 1969
1914 hy $1,111.00 December 31, 1969 0
1915 ola $0.00 December 31, 1969 11123
1916 4 $0.00 December 31, 1969 0
1917 test $0.00 December 31, 1969 0

New Row

Edit Row Id Item Description Price Date Quantity Delete Row
$0.00 December 31, 1969