format table

  1. H

    Convert text to number for a table

    How can I convert a large table of numbers stored as text to actual numbers...without going one by one? I tried highlighting all cells in the table and formatting them from text to numbers, but this didn't work. Thanks, Jeff
  2. L

    Identical Headings-formatting as table/chart adds digit

    Hi Excel Experts! This may be a dumb question answered elsewhere, but I don't think I'm asking the right questions w/correct terminology. Help!? I have several Excel-based reports that have to be formatted as tables and charts. Before using FORMAT AS TABLE command, the data looks like this...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top