Forum Discussion
Excel Cell Format won't change
I have various cells with numbers data saved as 'Special format - Chinese'. I have tried to change this to Custom format of 000000 as I need 6 digit numbers. However, this won't change and still show...
Don't worry about it. 000000 happens to be a special format in Chinese, so Excel lists it as such. It will still work as 000000.