Currency - Datatables for Laravel [ Datatables for Laravel ](/) [ 1.0.5](https://laravel-datatables.com/release-notes "Click to view release notes") Toggle main menu [Docs](https://laravel-datatables.com/docs) [Demos](/demos) [Blog](https://laravel-datatables.com/blog) [Pricing](/pricing) Search ⌘ K [ Log in ](/login) [Docs](https://laravel-datatables.com/docs) [Demos](/demos) [Blog](https://laravel-datatables.com/blog) [Pricing](/pricing) Search docs and demos Type at least 2 characters to search. Demos ### Use Cases - [ Simple Datatable ](https://laravel-datatables.com/demos/use-case-simple) - [ Products Datatable ](https://laravel-datatables.com/demos/use-case-products) - [ Sales Operations ](https://laravel-datatables.com/demos/use-case-sales) ### Features - [ Accessibility ](https://laravel-datatables.com/demos/features-accessibility) - [ Advanced Filtering ](https://laravel-datatables.com/demos/features-advanced-filtering) - [ Aggregate Totals ](https://laravel-datatables.com/demos/features-aggregate-totals) - [ Column Reordering ](https://laravel-datatables.com/demos/features-column-reordering) - [ Custom Controls ](https://laravel-datatables.com/demos/features-custom-controls) - [ Directionality (LTR / RTL) ](https://laravel-datatables.com/demos/features-directionality) - [ Export ](https://laravel-datatables.com/demos/features-export) - [ Frozen Columns ](https://laravel-datatables.com/demos/features-frozen-columns) - [ Frozen Header ](https://laravel-datatables.com/demos/features-frozen) - [ Frozen Header & Columns ](https://laravel-datatables.com/demos/features-frozen-both) - [ Pagination ](https://laravel-datatables.com/demos/features-pagination) - [ Responsive Mobile ](https://laravel-datatables.com/demos/features-responsive-mobile) - [ Row Grouping ](https://laravel-datatables.com/demos/features-row-grouping) - [ Row Selection & Bulk Actions ](https://laravel-datatables.com/demos/features-row-selection-bulk-actions) ### Cell Renderer - [ Action Buttons ](https://laravel-datatables.com/demos/cell-renderer-action-buttons) - [ Avatar ](https://laravel-datatables.com/demos/cell-renderer-avatar) - [ Checkmark ](https://laravel-datatables.com/demos/cell-renderer-checkmark) - [ Color Sample ](https://laravel-datatables.com/demos/cell-renderer-color-sample) - [ Email Link ](https://laravel-datatables.com/demos/cell-renderer-email) - [ External Link ](https://laravel-datatables.com/demos/cell-renderer-external) - [ Friendly Timestamp ](https://laravel-datatables.com/demos/cell-renderer-friendly-timestamp) - [ Image ](https://laravel-datatables.com/demos/cell-renderer-image) - [ Long Text ](https://laravel-datatables.com/demos/cell-renderer-long-text) - [ Phone Link ](https://laravel-datatables.com/demos/cell-renderer-phone-link) - [ Progress Bar ](https://laravel-datatables.com/demos/cell-renderer-progress-bar) - [ Status Badge ](https://laravel-datatables.com/demos/cell-renderer-status-badge) - [ URL Link ](https://laravel-datatables.com/demos/cell-renderer-url) - [ Wire Link ](https://laravel-datatables.com/demos/cell-renderer-wire) ### Value Formatter - [ Compact Number ](https://laravel-datatables.com/demos/value-formatter-compact-number) - [ Currency ](https://laravel-datatables.com/demos/value-formatter-currency) - [ Duration ](https://laravel-datatables.com/demos/value-formatter-duration) - [ Friendly Filesize ](https://laravel-datatables.com/demos/value-formatter-friendly-filesize) - [ Friendly Timestamp ](https://laravel-datatables.com/demos/value-formatter-friendly-timestamp) - [ Locale Timestamp ](https://laravel-datatables.com/demos/value-formatter-locale-timestamp) - [ Number ](https://laravel-datatables.com/demos/value-formatter-number) - [ Percent ](https://laravel-datatables.com/demos/value-formatter-percent) Currency ======== Compare standard and accounting output across several locales without changing the source values. This example queries the products table and creates a random profit column that shows positive and negative profit for input for the currency formatter. Currency modes Choose standard or accounting output. Standard Accounting Items per page Manage Columns 10 Current 25 50 100 ​ ### Manage Columns Apply Cancel Loading... ID Name SKU Stock Units Sold Price Revenue Expenses 1 Cumque et ullam #1 SKU-00000001 85 915 $487.94 $44,646.51 -$15,626.28 2 Nesciunt doloribus voluptatum #2 SKU-00000002 982 18 $375.07 $675.13 -$236.29 3 Et ullam dignissimos #3 SKU-00000003 290 710 A$485.74 A$34,487.54 -A$12,070.64 4 Exercitationem sapiente nihil #4 SKU-00000004 164 836 CA$108.78 CA$9,094.01 -CA$3,182.90 5 Vel tempore dolores #5 SKU-00000005 860 140 CA$211.49 CA$2,960.86 -CA$1,036.30 6 Qui consequatur sed #6 SKU-00000006 0 1K £422.27 £42,227.00 -£14,779.45 7 Sit quae occaecati #7 SKU-00000007 866 134 $374.05 $5,012.27 -$1,754.29 8 Esse nihil quam #8 SKU-00000008 0 1K £437.97 £43,797.00 -£15,328.95 9 Corporis dolorum est #9 SKU-00000009 988 12 £144.12 £172.94 -£60.53 10 Ut explicabo quia #10 SKU-00000010 693 307 A$364.24 A$11,182.17 -A$3,913.76 « Previous Next » 1 - 10 of 1000 1 2 3 4 5 6 7 8 9 10 ... 99 100 Items per page Manage Columns 10 Current 25 50 100 ​ ### Manage Columns Apply Cancel Loading... ID Name SKU Stock Units Sold Price Revenue Expenses 1 Cumque et ullam #1 SKU-00000001 85 915 $487.94 $44,646.51 ($15,626.28) 2 Nesciunt doloribus voluptatum #2 SKU-00000002 982 18 $375.07 $675.13 ($236.29) 3 Et ullam dignissimos #3 SKU-00000003 290 710 A$485.74 A$34,487.54 (A$12,070.64) 4 Exercitationem sapiente nihil #4 SKU-00000004 164 836 CA$108.78 CA$9,094.01 (CA$3,182.90) 5 Vel tempore dolores #5 SKU-00000005 860 140 CA$211.49 CA$2,960.86 (CA$1,036.30) 6 Qui consequatur sed #6 SKU-00000006 0 1K £422.27 £42,227.00 (£14,779.45) 7 Sit quae occaecati #7 SKU-00000007 866 134 $374.05 $5,012.27 ($1,754.29) 8 Esse nihil quam #8 SKU-00000008 0 1K £437.97 £43,797.00 (£15,328.95) 9 Corporis dolorum est #9 SKU-00000009 988 12 £144.12 £172.94 (£60.53) 10 Ut explicabo quia #10 SKU-00000010 693 307 A$364.24 A$11,182.17 (A$3,913.76) « Previous Next » 1 - 10 of 1000 1 2 3 4 5 6 7 8 9 10 ... 99 100 - Demo code is available for licensed customers - ### Related Documentation [Compact Number Value Formatter Transform large numeric values into readable short formats.](https://laravel-datatables.com/docs/formatter-compact-number) [Percent Value Formatter Display numeric values as percentages.](https://laravel-datatables.com/docs/formatter-percent) [Number Value Formatter Display numeric values in a formatted manner.](https://laravel-datatables.com/docs/formatter-number) [Currency Value Formatter Display numeric values as formatted currency.](https://laravel-datatables.com/docs/formatter-currency) ### Related Demos [Number Value Formatter Format numbers according to the specified locale.](https://laravel-datatables.com/demos/value-formatter-number) [Percent Value Formatter Format numbers as percentages according to the specified locale.](https://laravel-datatables.com/demos/value-formatter-percent) [Currency Value Formatter Format numbers as currency values according to the specified locale and currency code.](https://laravel-datatables.com/demos/value-formatter-currency) © 2026 Copyright (C) [ Morrow IT Consulting & Services ](https://morrow-it.services) [Terms of Service](https://laravel-datatables.com/legal/terms) [Privacy](https://laravel-datatables.com/legal/privacy) [Legal Disclosure](https://laravel-datatables.com/legal/disclosure)