Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Need to represent decimal number as "## hrn. ## kop.". Example:

1.2 => 1 hrn. 20 kop.
3 => 3 hrn. 00 kop.

I've created custom cell format:

0," hrn. "#0" kop."

Result is:

1.2 => 1, hrn. 20 kop.

How to remove this comma after 1? Is there another way to solve it?

share|improve this question

migrated from May 16 '13 at 1:18

This question came from our site for professional and enthusiast programmers.

Try using this format:

# " hrn". #0" kop."

Or modify yours to:

0, " hrn". #0" kop."

It's working for me.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .