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.

  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

  • 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
  • 3
    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
  • 1
    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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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