- Select the column of numbers that you want to modify.
- Right-click on the selected cells and choose "Format Cells" from the drop-down menu.
- In the "Format Cells" dialog box, select the "Custom" category.
- In the "Type" field, enter the following format: .
- Click "OK" to apply the format to the selected cells.
This will add the letter
"B" in front of every number in the selected column. The
"0" in the format ensures that any leading zeros in the original number are preserved.