The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

Custom Format Excel

Custom Format Excel


Hi I just saw the custom format video for Excel. I understood it but I want to know whether it can be applied to my problem and if yes, then how?
My problem:
Column – Cost per Kg (kg specifically written at the end of every number)




Is there any way in which I can apply custom formatting and make excel recognize this as number instead of General??

3 Answers

365 Team

Hi Srajan!
Thanks for reaching out.
You need to go through the following steps to do that.

  1. Select the cells that you wan to format (e.g. Column J)
  2. Expand the Number tab by pressing the arrow located in the down-right part of the tab
  3. In the list with Categories, choose Custom
  4. Then, as a type, choose a number (e.g. an integer), and add the words/letter that you want to appear in the cell in double quotation marks (e.g. – Type: 0 “kg” )
  5. Click “OK” to confirm.

Then, after you type numbers in the cells to which you’ve applied this characteristic, and then press “Enter”, the letters (e.g. “kg”) that you’ve designated, will appear.
Hope this helps.
The 365 Team


Thanks for the reply. I understood it. But it does not solve the query I was looking for.
But I understood one think that the custom formatting is only for changing the display the cell. NOT THE CONTENT OF THE CELL.
What I was looking for is to convert the already entered data (10kg) in worksheet that is in “General”  format to “number” format. So that I don’t have to separate the numbers (10) and the text (kg) into two different cells and then apply multiplication on the cell which only contains the number.
Although I have found a workaround. 
I used text to column converter of excel and used “fixed width” option to separate the number and “kg” attached at the end. After that using the custom formatting as suggested by you to insert “kg” at the end. 😀 ^^ 

Hi Srajan, I tried your method but I get this format displayed
10 kg kg
20 kg kg
30 kg kg
But the value still remains as 10 and kg for each row. Do you mean like this?

1 month

365 Team

Great job 🙂
I realize we need to add a more in-depth lecture on this topic.

Complete Data Science Education
Get 50% OFF