Aug 25 2020 01:22 AM
Hi team,
I facing a problem that formula always ran out, anyone knows how to solve?
You may see below picture that showing #####, actually the original format is general, but it changed automatically after I open it few days later. Sometime it changed to currency, or even date etc, but not the original format - general..
Aug 25 2020 02:20 AM
Hi @pearltho,
It is column width issue, please expand the width & if the issue still the same then request you attached the sample file.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it mor
Aug 25 2020 06:58 PM
Hi, the format itself already changed to date automatically.. my original format should be general, the data should be just number, eg. 100, 200...
this is what it shows if make the cells wider.
Aug 25 2020 07:17 PM
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.
Aug 25 2020 08:41 PM - edited Aug 25 2020 08:42 PM
@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.
Aug 25 2020 09:20 PM - edited Aug 25 2020 09:41 PM
Many thanks@Riny_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.