Thread: [Solved] Fix the numerical table column headings to General or Number Format
View Single Post
 
Old 03-14-2021, 01:09 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Hi
  • table headings are always converted to text
  • once again, formatting has nothing to do with the underlying values, it is the way XL shows us the data
  • while building your sheets DO NOT use manual column alignment. It looks nice but hides the fact that the cell content is text or number . Apply this at the finishing stage
And the other approach would be =INDEX(Table2_Salary;MATCH([@[SALARY GRADE]];Table2_SG);MATCH([@[SALARY STEP]]&"";Table2_Step))
Reply With Quote