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 shows as ‘Special Format’. I have also tried to use the option of Data and then text to column before changing this to Custom format and this don’t work either. Is there someone who can kindly assist with this>
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 shows as ‘Special Format’. I have also tried to use the option of Data and then text to column before changing this to Custom format and this don’t work either. Is there someone who can kindly assist with this> Read More