| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format: General - Text - General
I find myself converting formulas to text frequently so I can copy/paste them without the forumlas updating, then formatting back to general. When I do this, the value still shows the text format until I open and close(double click cell- press enter) each cell. How do I get the values to show up without that? TIA -- iturnrocks ------------------------------------------------------------------------ iturnrocks's Profile: http://www.excelforum.com/member.php...o&userid=37246 View this thread: http://www.excelforum.com/showthread...hreadid=570790 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text File creates incorrect Date format | Excel Discussion (Misc queries) | |||
| Retain Numbers as Text Format When Importing. | Excel Discussion (Misc queries) | |||
| converting general cells format to text | Excel Discussion (Misc queries) | |||
| Changing cell format - for example text to numeric | Excel Discussion (Misc queries) | |||
| how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions | |||
Threaded Mode
