Just set the format to General. If a string is returned from the function, such as 0123, it will display 0123 instead of 123.


On 13-Dec-2009 12:47, Robert Crandal wrote:
If i enter that formula into cell A1 (which is a text cell), then
Excel will simply enter the above formula as a string, instread
of running the function.