| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing the currenc setting of a cell or range
I have a macro that copies data from other workbooks. The problem is that the
data always displays with the $ sign when it should be the £ sign. The source data is defined as £. when I go in the format, options and select currency and £ it will not change the cell. Most annoying, please help Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a named range with a changing cell reference | New Users to Excel | |||
| Changing cell references in a Range to Absolute | Excel Discussion (Misc queries) | |||
| changing the value of each cell in a range by a certain percentage | Excel Discussion (Misc queries) | |||
| Setting a range with the last used cell? | Excel Programming | |||
| Setting a range value to the last cell in active worksheet. | Excel Programming | |||
Threaded Mode
