Web Applications Stack Exchange is a question and answer site for power users of web applications. 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

I am really scratching my head, but it seems like this is not possible in Google Spreadsheets. I want to format a number cell in kroner without any decimals. All I get is "kr 38,434.00" I want this number without any decimals. Could it really be that this is not possible.

share|improve this question
up vote 3 down vote accepted
  1. Select the cell with the number.
  2. Click the number format button on the toolbar.
  3. Select the decimal-less currency format.

enter image description here

share|improve this answer
There seems to be no decimal-less currency format for kr. I can find it for Dollars, though. – David Jan 31 '12 at 1:20
If you don't see different currency formats, click on File -> Spreadhseet settings and change the locale to United States. – dnbrv Jan 31 '12 at 1:23
Hey! I changed the locale to "Denmark" and kr. showed up as a currency-less option in the list. Thanks! – David Jan 31 '12 at 1:26
I meant, "decimal-less option". – David Jan 31 '12 at 15:07

In Google New Sheets - being rolled out in April 2014, setting currencies and decimals are split, as you can set the currency first (now hidden at Format -> Number -> More Formats -> More currencies) and then use the Decrease/Increase buttons to change the decimals:

enter image description here

Note that I found a bug in that if you decrease decimals on multiple cells, then they will all be reset to the currency of the first cell - so select each currency on its own.

It is not as of 2014-04 possible to 'upgrade' existing sheets to the 'New sheets' as far as I know.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.