| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying a cell and changing the formating from number to text
I have a spreadsheet that has numbers and number/letter combinations that I
am trying to reformat to text so it will sort like a text sort versus a number. I have tried refromatting all cells to text but it still does not sort correctly. Is there a way to copy to contents of the cell to another location and change the formatting to text? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formating a number in a cell | Excel Discussion (Misc queries) | |||
| Copying and pasting table info and cell formating in one hit | Excel Discussion (Misc queries) | |||
| copying info from one cell to another, changing the format, but leaving the number | Excel Worksheet Functions | |||
| edit number in cell without it changing to text | Excel Discussion (Misc queries) | |||
| Changing cell or text color depending on week number | Excel Discussion (Misc queries) | |||
Threaded Mode
