# Convert number to chinese words

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

## Convert number to Chinese words in Excel

```=TEXT(A1,"[DBNUM2]0億0仟萬0佰萬0拾萬0萬0仟0佰0拾0元")
```

## Convert number to Chinese words in Google sheet

Source of formula: PTT[1]

```=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(A1,"0億0仟0佰0拾0萬0仟0佰0拾0元"),"1","壹"),"2","貳"),"3","參"),"4","肆"),"5","伍"),"6","陸"),"7","柒"),"8","捌"),"9","玖"),"0","零")
```

Apps script version

```function NUMBER2HANS(input) {

let numbers = '0123456789'
let hans = '零壹貳參肆伍陸柒捌玖'
const hans_digits = ['元', '拾', '佰', '仟', '萬', '拾萬', '佰萬', '仟萬', '億']
//input = input.trim()
//input = input.replace(/^\s+|\s+\$/gm,'');
let length = input.length;
//console.log("length: " + length);

maxLength = 9; // maxLength is the max string length, not max # of fills
length = input.length;

let output = ''
for (let i = 0; i < input.length; i++) {
let currentDigit = length - i - 1;
//console.log("currentDigit: " + currentDigit);
let currentHansDigit = hans_digits[currentDigit];
//console.log("currentHansDigit: " + currentHansDigit);

let currentChar = input.charAt(i)
//console.log("currentChar: " + currentChar);

let currentHans = hans.charAt(currentChar)
//console.log("currentHans: " + currentHans);
//let output = currentHans + currentHansDigit
output += currentHans + currentHansDigit
//console.log("output: " + output);
}

return output
}

```