Title: Single Cell Content Shortcode
Last modified: October 20, 2017

---

# Single Cell Content Shortcode

 *  Resolved [Sam L.](https://wordpress.org/support/users/scionet/)
 * (@scionet)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/single-cell-content-shortcode-3/)
 * Hello
    I’m using Single Cell Content Shortcode to get data from Table 1 to Table
   2. Table 2 is the final table that will post onto the website. Table 1 contains
   just raw unformatted numbers.
 * When I use the shortcode [table-cell id=123 row=3 column=3 /] and put $[table-
   cell id=123 row=3 column=3 /]
    I can make the return data a dollar amount. Is
   there a way to make the return data contain commas within numbers? (For example
   return 565000000 to $565,000,000)
 * Thank you in advance for any guidance or assistance.

Viewing 13 replies - 1 through 13 (of 13 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/single-cell-content-shortcode-3/#post-9609022)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * For that, you would have to use e.g. the `NUMBER_FORMAT()` formula: [https://tablepress.org/tablepress-features-formulas/](https://tablepress.org/tablepress-features-formulas/)
 *     ```
       =${NUMBER_FORMAT([table-cell id=123 row=3 column=3 /],0)}
       ```
   
 * Before this works, you will have to also install a TablePress Extension that 
   is explained at [https://wordpress.org/support/topic/referencing-data-from-another-tables-and-formulas/#post-7012433](https://wordpress.org/support/topic/referencing-data-from-another-tables-and-formulas/#post-7012433)(
   which basically allows using the Shortcodes in formulas).
 * Regards,
    Tobias
 *  Thread Starter [Sam L.](https://wordpress.org/support/users/scionet/)
 * (@scionet)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/single-cell-content-shortcode-3/#post-9610124)
 * Hello
 * I install and activated the plugin: Parse Shortcodes before Formulas.
    Then added
   your formula:
 * =${NUMBER_FORMAT([table-cell id=105 row=12 column=2 /],0)}
 * and got the following error message:
    $!ERROR! illegal character ‘[‘
 * Any thoughts on if the formula is missing something? Thank you
 *  Thread Starter [Sam L.](https://wordpress.org/support/users/scionet/)
 * (@scionet)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/single-cell-content-shortcode-3/#post-9610176)
 * Please disregard my last message. I figured out my error. This works perfectly!
   Thank you so much.
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/single-cell-content-shortcode-3/#post-9610732)
 * Hi,
 * no problem, you are very welcome! 🙂 Good to hear that this helped!
 * Best wishes,
    Tobias
 * P.S.: In case you haven’t, please [rate TablePress](https://wordpress.org/support/plugin/tablepress/reviews/#new-post)
   here in the plugin directory. Thanks!
 *  Thread Starter [Sam L.](https://wordpress.org/support/users/scionet/)
 * (@scionet)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/single-cell-content-shortcode-3/#post-9612138)
 * FYI. When I add the shortcode: [table id=1 shortcodes_before_formulas=true /]
   
   all the other tables on that page that I use the Features of the DataTables JavaScript
   Library are automatically disabled.
 * I tried with to add [table id=2 shortcodes_before_formulas=false /] to the table
   that use Features of the DataTables JavaScript Library, but it does not work.
    -  This reply was modified 8 years, 7 months ago by [Sam L.](https://wordpress.org/support/users/scionet/).
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/single-cell-content-shortcode-3/#post-9612352)
 * Hi,
 * that doesn’t make sense. This Shortcode parameter on one table definitely has
   no influence on the other tables. Can you please post a link to the page with
   the table where this problem happens, so that I can take a direct look? Thanks!
 * Regards,
    Tobias
 *  Thread Starter [Sam L.](https://wordpress.org/support/users/scionet/)
 * (@scionet)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/single-cell-content-shortcode-3/#post-9612559)
 * This page DOES NOT have the shortcode [table id=1 shortcodes_before_formulas=
   true /]:
 * notice the Holdings table on the middle with sorting features.
 * This page DOES have the shortcode [table id=1 shortcodes_before_formulas=true/]
 * notice Holdings table on the middle does not have sorting features if when that
   option is selected. The shortcodes before formulas is placed in the table that
   has the header Market Data.
 * When I remove the shortcode before formulas, the page loads with all the features.
 * Thank you Tobias.
    -  This reply was modified 8 years, 7 months ago by [Sam L.](https://wordpress.org/support/users/scionet/).
    -  This reply was modified 8 years, 7 months ago by [Sam L.](https://wordpress.org/support/users/scionet/).
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/single-cell-content-shortcode-3/#post-9612663)
 * Hi,
 * it seems like you are entering the Shortcode into the “Custom Commands” text 
   field. That’s the wrong place.
 * You should modify the Shortcode that you already have on that page.
 * Regards,
    Tobias
 *  Thread Starter [Sam L.](https://wordpress.org/support/users/scionet/)
 * (@scionet)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/single-cell-content-shortcode-3/#post-9612729)
 * Thank you!!! That worked. I so very much appreciate your help and this tremendous.
   Please look for a donation to your PayPal today.
 *  Thread Starter [Sam L.](https://wordpress.org/support/users/scionet/)
 * (@scionet)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/single-cell-content-shortcode-3/#post-9613170)
 * Sorry, donation went to Amazon. We do not have a PayPal account – one must sign
   up for PayPal account donate to you.
    -  This reply was modified 8 years, 7 months ago by [Sam L.](https://wordpress.org/support/users/scionet/).
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/single-cell-content-shortcode-3/#post-9613387)
 * Hi,
 * no problem, you are very welcome! 🙂 Good to hear that this helped!
    And thanks
   for donating, I really appreciate it! 🙂
 * Best wishes,
    Tobias
 * P.S.: In case you haven’t, please [rate TablePress](https://wordpress.org/support/plugin/tablepress/reviews/)
   here in the plugin directory. Thanks!
 *  [larsgustav](https://wordpress.org/support/users/larsgustav/)
 * (@larsgustav)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/single-cell-content-shortcode-3/#post-9794216)
 * Hello
    I’m using Single Cell Content Shortcode to get data from Table 1 to a 
   webside. Content of the cell is a formula like =**{SUM(C2:C11)} €** What is output
   is the text of the formula. What do I have to do to get the value? Thank you!
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 5 months ago](https://wordpress.org/support/topic/single-cell-content-shortcode-3/#post-9796064)
 * Hi,
 * thanks for your question, and sorry for the trouble.
 * Unfortunately, this is not possible. The Single Cell Shortcode Extension can 
   only retrieve the raw data, which is the formula. Sorry.
 * Regards,
    Tobias

Viewing 13 replies - 1 through 13 (of 13 total)

The topic ‘Single Cell Content Shortcode’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

## Tags

 * [formula](https://wordpress.org/support/topic-tag/formula/)
 * [value](https://wordpress.org/support/topic-tag/value/)

 * 13 replies
 * 3 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [8 years, 5 months ago](https://wordpress.org/support/topic/single-cell-content-shortcode-3/#post-9796064)
 * Status: resolved