A friend has asked if there any way to convert a number in a cell to formatted text? For example, A1 = 1233. He wants to (in another cell) refer to A1 and convert 1233 to "one thousand, two hundred and thirty three". I am not an Excel expert but I told him that if this was possible, someone in the lounge would have an answer. I can't find any function that would accomplish this - VBA perhaps? Thanks in advance.