S Stan in South Africa Nov 10, 2008 #1 Office 2007, Xp Pro I have cells with text format, ie 0117401342 How do I format to 011 740 1342?
P Peo Sjoblom Nov 10, 2008 #3 Not possible to customize formatting for text. If they were numbers you can use 000 000 0000 assuming the number of digits are constant any other way would require an event macro -- Regards, Peo Sjoblom
Not possible to customize formatting for text. If they were numbers you can use 000 000 0000 assuming the number of digits are constant any other way would require an event macro -- Regards, Peo Sjoblom
J James Silverton Nov 10, 2008 #5 Peo wrote on Mon, 10 Nov 2008 09:29:59 -0800: 000 000 0000 Click to expand... assuming the number of digits are constant Click to expand... any other way would require an event macro Click to expand... Of course, if you are willing to have the text numbers in A and another column, say B, formatted 000 000 0000, you could make, say, B1=VALUE(A1). -- James Silverton Potomac, Maryland Email, with obvious alterations: not.jim.silverton.at.verizon.not
Peo wrote on Mon, 10 Nov 2008 09:29:59 -0800: 000 000 0000 Click to expand... assuming the number of digits are constant Click to expand... any other way would require an event macro Click to expand... Of course, if you are willing to have the text numbers in A and another column, say B, formatted 000 000 0000, you could make, say, B1=VALUE(A1). -- James Silverton Potomac, Maryland Email, with obvious alterations: not.jim.silverton.at.verizon.not
