Have prepared some date in Excel containing several columns of test/numbers. All the columns were formatted to the left. Have uploaded the table into Access and have some simple queries to search and display the tables. The queries have all formatted to the right. Looking in HOME, the TEXT FORMATTING BOX is grayed out and has no effect. Can this be unlocked? Can't find any other formatting method. Thanks in advance.