|
|
#1
03-13-2021, 11:51 PM
|
||||
|
||||
Fix the numerical table column headings to General or Number Format
Hi. In the attached workbook, the first sheet has a formula that pulls values from the second sheet according to the set criteria through the INDEX MATCH functions. My problem is that when I converted the source data into a table, the formula returned error results. The column headings which are numbers were turned into text. I tried formatting the headings into numbers and general but still the errors remain. Typing an apostrophe before the number in the first sheet just so the errors would be eliminated is incorrect.
The temporary workaround is to exclude the column headings in the table but the data source looks ugly. Any idea on how to straighten the column headings? Thank you. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 VBA convert to table - format Column 1
|
Shelley Lou | Word VBA | 4 | 01-29-2021 05:44 AM |
| Use a numerical merge field to subtract that number of months | MichaelSpedding | Mail Merge | 8 | 11-11-2015 01:11 PM |
| VBA to Format a Table Column in Excel | Sgt Rock | Excel | 0 | 02-14-2015 02:54 PM |
|
1.image in a table 2.right click 3.menu click format 4.a format column appears
|
OldFatDog | Drawing and Graphics | 1 | 06-13-2014 11:19 PM |
| Change from General Format to number format | gbaker | Excel | 3 | 08-16-2013 01:04 PM |
Windows 7 32bit 
Office 2013
Threaded Mode