| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help please, cell formatting only works after I double click the cell
I have a worksheet with about 28000 records that I pulled from MS Access. The phone number column is left justified and has a little green arrow indicating there is an error of some type. The error balloon says " the number in this cell is formatted as text or is preceeded by an apostophe". I try to set the formatting as Special-Phone Number but nothing happens. However if I double click on the cell and then click an ajoining cell the formatting works. How can I fix the entire column without having to double click on 28000 cells? -- Mycotopian ------------------------------------------------------------------------ Mycotopian's Profile: http://www.excelforum.com/member.php...fo&userid=4673 View this thread: http://www.excelforum.com/showthread...hreadid=563009 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help please, cell formatting only works after I double click the c
Format as phone number, use DataText to Column to convert from Text to a
Number. "Mycotopian" wrote: I have a worksheet with about 28000 records that I pulled from MS Access. The phone number column is left justified and has a little green arrow indicating there is an error of some type. The error balloon says " the number in this cell is formatted as text or is preceeded by an apostophe". I try to set the formatting as Special-Phone Number but nothing happens. However if I double click on the cell and then click an ajoining cell the formatting works. How can I fix the entire column without having to double click on 28000 cells? -- Mycotopian ------------------------------------------------------------------------ Mycotopian's Profile: http://www.excelforum.com/member.php...fo&userid=4673 View this thread: http://www.excelforum.com/showthread...hreadid=563009 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to click on a cell and have the content of the cell display in a different cell | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
| How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
