left justify text excel right justify numbers

For information about using the TEXT function, see TEXT function. For examples of this technique, see Keep leading zeros in number codes. You can also use the TEXT function to convert a number to text in a specific number format. For more information, see Convert numbers stored as text to numbers. In this scenario, you must convert the numbers stored as text back to numbers. This sometimes happens when you import or copy numbers from a database or other data source. Occasionally, numbers might be formatted and stored in cells as text, which later can cause problems with calculations or produce confusing sort orders.

For more information about this issue, see Create or delete a custom number format and Keep leading zeros in number codes. In this case, you could create a custom number format consisting of the code 0000000000, which forces Excel to display all ten digits of the product code, including the leading zero. For example, if you're typing or pasting ten-digit product codes in a worksheet, Excel will change numbers like 0784367998 to 784367998.

If you want to control where the information goes on the sheet, use a longer entry in the center section that includes the information that you want toward the right, and pad the entries with spaces.

If this is not what you want, you can create a custom number format that forces Excel to retain the leading zero. By default, right-align is the only option for the right footer, just as left-align is used for the left, an center for the center. When you enter a number that begins with a zero-for example, a product code-Excel will delete the zero by default. To use decimal places in numbers that are stored as text, you may need to include the decimal points when you type the numbers.

Left justify text excel right justify numbers