| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to format cell data HELP please
Hi,
My spreadsheet won't let me format an 'Email Address' or a 'Web Address' column with active email or web addresses. Each time I select a cell the entry in the editable bar at the top (the formula bar) shows a ' before the text or number. If I delete the ' that precedes the text or number, all is well and hyperlinks look like hyperlinks etc..... Is there a way to remove this ' from all cells at once? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Copying the data in and format of a cell to another cell | Excel Discussion (Misc queries) | |||
| Cell data format | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
| format cell data to display stacked data | Excel Discussion (Misc queries) | |||
Threaded Mode
