| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell * figure
When I select paste special it just shows Unicode text or regular text.....
It makes sense but doesn't work with this office 2000... "Gord Dibben" wrote: Current rates are 1.16 cdn to 1 us. us * 1.16 = cdn Enter 1.16 in an empty cell. Copy that. Select column with us prices and Paste SpecialMultiplyOKEsc. Clear the cell with 1.16. Gord Dibben Excel MVP On Fri, 23 Dec 2005 19:45:02 -0800, "suegr" wrote: I have a Price column. It is in US dollar and I need it to convert Canadian dollars. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
| Percentage difference calc that knows the largest figure | Excel Discussion (Misc queries) | |||
| change the colour of text in cell for minus figure | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Hybrid Mode
