Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed please
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed please
This can be done if you can precisely define a valid phone number for your
purpose. Does it include area code? Can it include international codes? Update this post with your criteria. -- Gary''s Student - gsnu2007a "TheGodfather" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed please
On Oct 28, 12:40 pm, Gary''s Student
wrote: This can be done if you can precisely define a valid phone number for your purpose. Does it include area code? Can it include international codes? Update this post with your criteria. -- Gary''s Student - gsnu2007a "TheGodfather" wrote: 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. yes indeed it must have the ability of entering area codes and international codes like (+1) or (+30) i want the user to be able to enter any number , the + sign of course or the "00"(when she enters 00 , the 0's must show up) Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed please
On Oct 28, 1:50 pm, TheGodfather
wrote: On Oct 28, 12:40 pm, Gary''s Student wrote: This can be done if you can precisely define a valid phone number for your purpose. Does it include area code? Can it include international codes? Update this post with your criteria. -- Gary''s Student - gsnu2007a "TheGodfather" wrote: 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. yes indeed it must have the ability of entering area codes and international codes like (+1) or (+30) i want the user to be able to enter any number , the + sign of course or the "00"(when she enters 00 , the 0's must show up) Thanks a valid number is like : +306934778585 or +9613209845 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help needed please
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help needed | New Users to Excel | |||
Help needed | Excel Discussion (Misc queries) | |||
MVP needed | Excel Discussion (Misc queries) | |||
help needed | Excel Discussion (Misc queries) | |||
Help Needed - Please | Excel Discussion (Misc queries) |