Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an SAP BW (Business Warehouse) report that is downloaded to Excel.
In this report the Volume is reported with various Units of Measure (e.g. KG, EA, LB, etc) and the Revenue is reported in different currency (e.g. EUR, CHF, JPY, or blank if it is USD). These formats are achieve via the "Format Cells - Custom" command with the format: #,##0 "KG";-#,##0 "KG"; or #,##0 "EUR";-#,##0 "EUR"; depending upon the unit of measure or currency of each record US Dollar sales are formated with a simple #,##0;-#,##0 I would like to move the text associated with the format (e.g. KG or EUR) to the column next to the cell the amount is in. I can not figure out how to identify the text part of the format of the cell such that cell A1 would contain the number in its current format (e.g. 123 EUR) and cell B1 would contain the text (e.g. EUR or KG). Can someone point me in the right VBA direction? Thanks, Frank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to add new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
How to set 2 currency format in 1 cell?? | Excel Discussion (Misc queries) | |||
Change Currency Format of Cell based on another Cell | Excel Worksheet Functions | |||
How do I change default unit of measure from cm to inches? | Setting up and Configuration of Excel | |||
start a macro or procedure based on user putting an x in a cell | Excel Discussion (Misc queries) |