Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ensuring a cell is copied in text format
I have a macro that uses the following code to copy the value from
the named range "a" to the named range "b" in another workbook: a.Formula = a.Value2 a.Copy b The problem is that the "b" cell gets formatted as Date, even though it's preformatted as Text and the "a" cell also is formatted as Text. (The "a" cell contains text like 11/2004, so the value is interpreted as a date on arrival.) I need to ensure that the "b" cell is formatted as Text, and that it doesn't convert the original text to a "date number" like 38292. How can this be done?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste copied text to only one cell | Excel Discussion (Misc queries) | |||
Time format in a cell getting copied automatically into another ce | Excel Discussion (Misc queries) | |||
cell format changes when formula copied? | Excel Worksheet Functions | |||
format cell to change color when copied | Excel Discussion (Misc queries) | |||
Why my cell format is not copied when I copied workbook? | Excel Programming |