Hi,
Thanks for your prompt response. My reply are as below:
1. I am unable to provide my files as those are confidential files however, I attached herewith a sample file for your attention. As you can see, the first three rows are the format which I have set-up according to my preference. The second three rows are new figures/data after I re-open the file. It seems that it goes back to default.
2. The settings I have chosen in the 'Tools' menu for language is Malay (Malaysian).
3. I always saved my files with 'xlsx' (Microsoft Office 2007/2010) settings as sometimes I do have to share some of my files with my colleagues who are mostly Windows users.
4. I do not understand fully the question but I guess I did the direct formatting. To describe it further, I just highlighted the entire column/row, right click at the highlighted column/row, chose 'Format Cell' and did the necessary changes in accordance with my preferences.
Hope my explanation above suffices.
Thank you.
regards,
Shahrizal Kamal