Forum Discussion
Excel Rejects a my Custom Number Format
Good Day. This may be a simple error on my part, but I am not an expert so I seek help. I have custom formatted a number on a worksheet to look like this: 1,100 Sq.m. using the custom number format...
I found an excellent work around to the Custom Formula Problem for the Web Version of Excel. Simply use the TEXT() formula. I wanted the value '1' (a numerical value) to be displayed as "001". Therefore I put the following formula in the cell '=Text("1", "000")' and viola it displays the custom format. Funny how the functionality remains in the web version but developers could unlock this feature. Maybe there are some more difficult number formatting that cannot be done with the Text () formula.