The problem i am facing is that once i applied this format, save and close the workbook. The following symbols may be used to format numbers as well as text. The problem with the above technique is that formating the wrap text will eliminate any placeholders you put in place to help with the alignment formating.