Skip to content

Cookie settings

Choose which kinds of cookies you allow. You can change your choice at any time via Cookie settings at the bottom of every page. Privacy statement

Necessary

Always on

Needed to log in, keep your cart and remember your choices. These are always on.

Which cookies?
  • weboke_sessie, weboke_klant, weboke_remember: your session and staying logged in
  • weboke_basket: your cart
  • wkBtwIncl: showing prices with or without VAT
  • wok_cookies: your cookie choice, 12 months

Measures which ad leads to a visit or order, so we do not pay for ads that do nothing.

Which cookies?
  • Google Ads via Google Tag Manager (_gcl_au, _gcl_aw), up to 90 days
  • OpenAI Ads, ads in ChatGPT
  • wok_aff: which partner referred you to us (affiliate programme), 60 days

4.6

Country and language

Each country has its own site, with prices and VAT for that country.

View

Custom number formats: "12 pcs", amounts in thousands, red for negatives

If you type "12 pcs" or "7.5 hrs" in a cell, it becomes text and you can no longer calculate with it. With a custom number format, the cell stays a number (12) while you still see "12 pcs". You can also use custom formats to show negative amounts in red, a dash instead of a zero, or amounts in thousands. The standard formats are covered in Formatting numbers, dates and currency; this article is about your own formats.

Where do you type a custom format?

  1. Select the cells.
  2. On the Home tab, click the number format drop-down list and choose More formats at the bottom.
  3. In the Number Format window, under Category, choose Custom.
  4. Type the code in the field under Format, or pick an existing code from the list and edit it. Under Preview you immediately see how the cell will look.
  5. Click OK.
A custom format in the Number Format window
Category Custom; you type the code in the field under Format (1). Under Preview you see the result straight away

The codes follow the notation of your region: in English, a full stop for decimals and a comma for thousands, as in #,##0.00. You can also see this in the codes Euro-Office itself puts in the list.

Useful codes

What you wantCodeNumberYou see
Pieces0" pcs"1212 pcs
Hours with one decimal0.0" hrs"7.57.5 hrs
Red for negative, dash for zero€ #,##0.00;[Red]-€ #,##0.00;"-"-830-€ 830.00 in red
In thousands#,##0.0,"k"12,34512.3k
Leading zeros (see also Keeping the leading zero in a phone number or postcode)000004200042
Text with a prefix0;-0;0;"status: "@orderedstatus: ordered
Numbers with custom formats
Column B contains numbers with custom formats: pieces, hours, amounts, a dash for zero, in thousands and in millions. In B5, -€ 830.00 is black: [Rood] was used there. In B10 it is red: that cell uses [Red]

How a code is built

  • 0 is a digit that is always shown, # a digit that only appears when needed.
  • Text goes between quotation marks: " pcs", " hrs".
  • A code can have up to four sections, separated by a semicolon: positive;negative;zero;text. If you leave sections out, Euro-Office uses the first section for everything.
  • You put a colour between square brackets at the start of a section. Euro-Office uses the English colour names: [Red], not [Rood].
  • A comma after the number code divides by a thousand: #,##0.0, shows 12,345 as 12.3. With two commas you divide by a million.
  • @ stands for the text in the cell.

Pitfalls

  • Typed units: if the cell already contains "12 pcs" as text, a format won't help. Retype just the number.
  • Letters without quotation marks: in a format, h, m, s, d and y mean hour, month, second, day and year. So always put text between quotation marks.
  • The number doesn't change: showing it in thousands doesn't mean the cell contains 12.3. Calculations still use 12,345.
  • A typo in the code quickly leads to an odd display. So check Preview before you click OK.

One moment…

Set up your domains

For each domain, arrange the nameservers, the link to your hosting and who becomes the owner.

Loading your domains…