└ Script-Value format

Script-Value format #

Number format #

formatNum_normal #

formatNum_normal
Change to a normal number format.
[yes - with right padding(accounting)] #,##0_-;[Red]-#,##0_-;-_-
[no - without right padding] #,##0;[Red]-#,##0;-


formatNum_thousand #

formatNum_thousand
Change in a thousand unit number format.
[yes - with right padding(accounting)] #,##0,-;[Red]-#,##0,-;-_-
[no - without right padding] #,##0,;[Red]-#,##0,;-


formatNum_mil #

formatNum_mil
Change in a million unit number format.
[yes - with right padding(accounting)] #,##0,,-;[Red]-#,##0,,-;-_-
[no - without right padding] #,##0,,;[Red]-#,##0,,;-


formatNum_date #

formatNum_date
Change to a date format containing the day.
[yes - with day of the week] yyyy-mm-dd(aaa)
[no - without day of the week] yyyy-mm-dd


delhyperlink
Delete hyperlinks. The format is all erased together.


delBlank #

delblank
Delete all the spaces of the selected cell.