All guides

Number formats, currencies and dates

A number format decides how a value looks: with a dollar sign, a percent sign, two decimal places or as a date. The value stays the same, so formulas still work. This guide shows the formats and how to apply them.

Step by step

1.Type numbers, currencies, percentages and dates

Papr reads what you type. 1234.5 is a number. $1,200 is an amount in dollars, and the cell gets a currency format. 50% is a percentage, stored as 0.5. A date such as 2026-10-13 is stored as a date and shows in your browser’s short date style, here 10/13/2026. Anything else, such as 5garbage, stays as text.

Four values in column A: 1234.5, $1,200.00, 50.0% and the date 10/13/2026.

2.Open the Number menu

Select the cells, then open the Number menu. It lists General, Number, Currency, Percent, Date, Time and Date & time. Below them, the menu lists currencies such as USD - US dollar and EUR - Euro.

The Number menu open, with the Currency item outlined in red and the currency list below it.

3.Change the decimal places

Select the numbers, then click Increase Decimal to show one more digit after the point, or Decrease Decimal to show one fewer. The buttons count from the digits the cells show now. Each click is one step you can undo.

The Increase Decimal button outlined in red, with the selected numbers showing an extra digit.

4.Apply a currency

Select the amounts, open the Number menu and choose a currency. The amounts show the currency’s sign, with the usual number of decimal places for it, two for dollars. Choosing a format sets the decimal places back to the format’s own, so change the decimal places after you choose the currency.

Two amounts in dollars, $1,234.50 and $1,200.00, with the second one selected and outlined in red.

5.Read dates

A date is stored as the number of days since a fixed starting day, so it can be subtracted from another date. The cell shows it in your browser’s short date style, and the formula bar shows the same text. The TODAY() function gives the current date in your own time zone.

A date cell showing 10/13/2026, outlined in red, with the same date in the formula bar.

Good to know

  • The formats are kept when you export to XLSX, so Excel shows the same currency and decimal places.
  • A format that Papr does not have, such as scientific notation or a fraction, is imported from an Excel file as a plain number, and the value is kept.

Try it on your own file

Papr Sheets runs in your browser. Your workbook stays on your device.

Open Papr Sheets
  1. Getting started with Papr Sheets
  2. How to use formulas in Papr Sheets
  3. How to import and export Excel and CSV files