| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dollar/Euro/Pound Excel macro
In EXCEL 2003, i am transferring data from Sheet1 to Sheet2. The data
includes one of the three currency signs ($,ぎ,ﾂ｣) in column 1 each time. Can anyone help with a macro that will read the currency sign and then apply that currency sign and format to other cells in the same row (C,D,E)- the same process being repeated each time a new row of data is added. e.g. A B C D E F 1 $ 25.00 $ 67.05 $ 98.00 $ 102.85 67.00 2 ﾂ｣ 34.00 ﾂ｣ 57.64 ﾂ｣ 87.00 ﾂ｣ 111.45 54.00 3 $ 198.00 $ 58.97 $ 25.00 $ 68.30 258.00 4 ぎ 62.57 ぎ 85.21 ぎ 58.00 ぎ 98.35 5.00 5 ﾂ｣ 7.54 ﾂ｣ 1.50 ﾂ｣ 69.00 ﾂ｣ 0.65 4.65 etc Many thanks for all the advice given - this is a steep but fascinating learning curve! Yendorian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dollar / Euro sign | Excel Worksheet Functions | |||
| Problem extracting Euro and Pound symbol | Excel Discussion (Misc queries) | |||
| Euro & British pound symbol issue | Excel Discussion (Misc queries) | |||
| How can I change dollar sybbol to euro symbol? | New Users to Excel | |||
| Can I disply Euro and Dollar Formats in the same spreadsheet | Excel Discussion (Misc queries) | |||
Threaded Mode
