| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Thanks to the both of you....a big help
"David McRitchie" wrote: Hi ...Catch 22... In rereading looks like the only thing you were concerned about is email addresses which would give you no problems converting to values as described by Fredrik. For numeric values you could have a problem with a value like 48.05038 but you only see 48.05 in Excel and you want to see 48.05 when printed in email. One way to solve that would be to use cell.text in your macro where cell is a single cell range that you are looping through cells. Strictly within Excel there is no problem because converting to value is not going to change the formatting. HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Fredrik Wahlgren" wrote in message Selct the cell(s), copy and then selct Edit|Paste Special.. Select values and press OK. You probably want to do this on a copy of your workbook. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text in Cell as Formula | Excel Discussion (Misc queries) | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
| merging text without using a formula | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
