A few words of thanks would be greatly appreciated.

Excel - Add a prefix to all records in a column

Microsoft Office Excel is a spreadsheet program which includes prop up for XML plus description that allows everybody to scrutinise and distribute information. Excel has visual basic for applications. Microsoft Office Excel has the crucial quality of all the spreadsheets, using a lattice of cells displayed in orderly rows and columns to categorise the statistics manipulations like calculation operations. The data is stored in all the grids. The saved data is changed or altered by adding a prefix to each of the columns. Many individuals are unaware of this process, but not to worry: here are some tips to add a prefix in Excel columns.


I want assign the 0(zero) prefix to all records in a particular column of an Excel sheet. Please let me know how to do it?


If the data is numeric then select the columns and put in:

Format > Cell > Number > Custom > write 0#,##.00

All your numbers will have 0 prefix ....

Note that

Thanks to mubashir aziz for this tip on the forum.

A few words of thanks would be greatly appreciated.

Ask a question
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team


Published by . Latest update on by Celia Gatward.

This document, titled "Excel - Add a prefix to all records in a column," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).