Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell conditional numeric and text
Simple question I'm sure. Trying to format cell with both numeric & text.
Phone number + alpha. (123) 123-12324 H Have tried: (###) ####-#### @ also with ; and _ Can't find solution Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell conditional numeric and text
Number formats only work with numbers--not text.
You could use a helper column that displays it nicely. If you type 1231231234H in A1 you could use this in B1: =TEXT(LEFT(A1,10),"(000) 000-0000 ")&RIGHT(A1,1) And drag down. Cyndy TN wrote: Simple question I'm sure. Trying to format cell with both numeric & text. Phone number + alpha. (123) 123-12324 H Have tried: (###) ####-#### @ also with ; and _ Can't find solution Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numeric Cell Value with text description | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Changing cell format - for example text to numeric | Excel Discussion (Misc queries) | |||
How to change default cell format to "Text" | Excel Discussion (Misc queries) | |||
Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) |