mumps,
I think they are using a system where a decimal point represented by a comma, not a period.
Hence, 1,2 K represents one-thousand two-hundred and 1,599 K represents one-thousand, five hundred, and ninety-nine.
So the "K" is just short-hand for "thousand".
lezawang,
Is that correct?
Are you regional settings in Excel already set up to use a comma instead of a period to indicate decimals?
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A:A")) Is Nothing Then Exit Sub
Application.EnableEvents = False
If Len(Target) > 3 Then
Target = Target / 1000 & " K"
End If
Application.EnableEvents = True
End Sub
I am using a system where a dot is my decimal point. What I don't know on your system is whether you use a dot or a comma for the decimal point when you do a Custom Format. Assuming you use a comma (meaning the dot is your thousands separator), try using this custom format...Hi
I want to write a code to format numbers like the following
number appears in excel 1200 1,2 K
1599 1,599 k
<tbody>
</tbody>
I found this code #,##0,
but did work as expected. Thank you very much.