Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apostrophe at the start of a cell
I have a list of place names, some of which start with an apostrophe (e.g.
'Awarta, and 'Ashira) but Excel won't show the apostrphe - it keeps hiding it even when I set the format to text. Not all names have an apostrophe and I want to be able to sort in alphabetical order so that Anabta would come before 'Awarta. The only way I can think of is to put a space in fromt of every name. Doeas anyone know how I can format the cell so that I don't have to have this space? Thansk Nic |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |