Forum Discussion
Formula issues
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..
6 Replies
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
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.
- make the cells wider
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.
