Thread: [Solved] Fix the numerical table column headings to General or Number Format
View Single Post
 
Old 03-14-2021, 12:51 AM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
=INDEX(Table2_Salary,MATCH([@[SALARY GRADE]],Table2_SG),MATCH([@[SALARY STEP]],Table2_Step+0))

Just add zero to the heading to make it a number

Dont know why it did it though
Attached Files
File Type: xlsx SalarySched_Purfleet.xlsx (34.0 KB, 8 views)
Reply With Quote