See the answer provided in the Worksheet.Function group.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"TheGodfather"

wrote in message
Hi all,
i would like to make a phone book in excel a data validation
constraint i want is in some rows to insert numbers only no text
allowed, and at the same time i want those numbers to be treated as
text to prohibit their calculation, i tried to format as text but then
text will be accepted , i tried data validation with the is number
function, but this wouldn't prohibit the calculation , i need a mix of
those two, to stop the user entering text and in the meanwhile treat
numbers entered as text.