# Numeric format strings

Following, you can find a reference for numeric format strings.

The following format strings apply to functions such as TO_NUMBER and TO_CHAR.

Format | Description |
---|---|

9 | Numeric value with the specified number of digits. |

0 | Numeric value with leading zeros. |

. (period), D | Decimal point. |

, (comma) | Thousands separator. |

CC | Century code. For example, the 21st century started on 2001-01-01 (supported for TO_CHAR only). |

FM | Fill mode. Suppress padding blanks and zeroes. |

PR | Negative value in angle brackets. |

S | Sign anchored to a number. |

L | Currency symbol in the specified position. |

G | Group separator. |

MI | Minus sign in the specified position for numbers that are less than 0. |

PL | Plus sign in the specified position for numbers that are greater than 0. |

SG | Plus or minus sign in the specified position. |

RN | Roman numeral between 1 and 3999 (supported for TO_CHAR only). |

TH or th | Ordinal number suffix. Does not convert fractional numbers or values that are less than zero. |