Special symbols with numerical value in Excel spreadsheet

January 10, 2019 at 01:52:00
Specs: Windows 10, 8GB
Hi everyone,

In Excel spreadsheet it is possible to format the cells in that way that some additional symbols can appear on the right side of the calculed (or manually entered) value using CTRL+1 and than the cell format specification like e.g. # ##0,0\ "€/h" so that we finally see e.g. "12,5 €/h"
But I'm wondering if it is possible to place the additional symbol like "km" ON THE LEFT SIDE side of the numerical value so that e.g."km 258" is displayed in the cell.

Thx a lot in advance for any ideas!


See More: Special symbols with numerical value in Excel spreadsheet

Reply ↓  Report •

January 10, 2019 at 05:01:49
Hi everyone,
I just have found the answer (very simple): it is sufficient to put the "km" infix before the string x xxx0,00 in the "Nonstandard format" of numbers.
Sorry, but when I tried it before it seemed not to work, so I decided to ask here.



Reply ↓  Report •

January 10, 2019 at 06:55:13
Just FYI, it can also be done using the Concatenation operator in the formula, but you do lose the ability to easily format the numerical section in the way that you might want. It can be done, but depending on the desired format, it can get complicated.

="km "&SUM(A1:A10)

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Reply ↓  Report •

January 10, 2019 at 07:48:53
Also, be aware that by adding the symbol to the left side of the number
you change the format to TEXT of the target cell
and if you want to do any calculations with the target cell,
you will have to cut the number out of the cell before use.

As a workaround you could put the KM symbol in one cell, IE A1
then, as DerbyDad suggested, Concatenate the two cells like:

=A1 &" "& SUM(B1:B4)



Reply ↓  Report •
Related Solutions

Ask Question