Custom - Built-in

You cannot delete any of the built-in number formats.

CategoryFormatPositiveNegativeZeroText
GeneralGeneral10.5-10.50text
Number010.5-10.50text
 0.0010.5-10.50text
 #,##010.5-10.50text
 #,##0.0010.5-10.50text
 #,##0;-#,##010.5-10.50text
 #,##0;[Red]-#,##010.5-10.50text
 #,##0.00;-#,##0.0010.5-10.50text
 #,##0.00;[Red]-#,##0.0010.5-10.50text
Currency$#,##0;-£#,##010.5-10.50text
 $#,##0;[Red]-£#,##010.5-10.50text
 $#,##0.00;-£#,##0.0010.5-10.50text
 $#,##0.00;[Red]-£#,##0.0010.5-10.50text
Percentage0%10.5-10.50text
 0.00%10.5-10.50text
Scientific0.00E+0010.5-10.50text
 ##0.0E+010.5-10.50text
Fraction# ?/?10.5-10.50text
 # ??/??10.5-10.50text
Datedd/mm/yyyy09/01/1900 12:00:0020/12/1899 12:00:0000:00:00text
 dd-mmm-yy09/01/1900 12:00:0020/12/1899 12:00:0000:00:00text
 dd-mmm09/01/1900 12:00:0020/12/1899 12:00:0000:00:00text
 mmm-yy10.5-10.50text
 dd/mm/yyyy hh:mm10.5-10.50text
Timeh:mm AM/PM10.5-10.50text
 h:mm:ss AM/PM10.5-10.50text
 hh:mm10.5-10.50text
 hh:mm:ss10.5-10.50text
 mm:ss10.5-10.50text
 mm:ss,010.5-10.50text
 [h]:mm:ss10.5-10.50text
Text@ (text placeholder)10.5-10.50text
Accounting_-£* #,##0_-;-£* #,##0_-;_-£* "-"_-;_-@_-10.5-10.50text
 _-* #,##0_-;-* #,##0_-;_-* "-"_-;_-@_-10.5-10.50text
 _-£* #,##0.00_-;-£* #,##0.00_-;_-£* "-"??_-;_-@_-10.5-10.50text
 _-* #,##0.00_-;-* #,##0.00_-;_-* "-"??_-;_-@_-10.5-10.50text

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext