Forum Discussion
Formula issues
Hi, it doesn't matter with the cells width, after make it wider, it still same.
the original format should be 'general' and showing number, etc 100, 5, 200....
but it change to date automatically.
here u go for the file.
pearltho All your numbers have a custom format "[$-en-MY,1]d/m/yyyy;@", turning them into dates. All cells with positive numbers will be displayed as date, starting with number 1 as January 1, 1900. Widen the cells and these positive numbers will show dates. Negatives numbers, however, can not be displayed as dates and will always result in #########, regardless the width of the cell.
But since you don't want dates, select all cells in a sheet, format as "General". Then select the columns that should be dates (columns A mostly) and format these as "Date" and all your numbers and dates will display as expected.
Many thanksRiny_van_Eekelen
I able to change it back to the format I want, the problem is, after few days, when I reopen the same file, the format will change again, that's why need your expert experience to share me how to avoid it change automatically.