| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert currency to general
Hi,
I was wondering is there any way to convert currency to a general format (or text). I need to export information from my AP application to my bank. However, the query comes out of the AP application as a currency field, and the bank wants it as text. 1e. $1,480.67 needs to have the $ , and . stripped out (while retaining the decimal places) so the bank receives it as 148067 Any help is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| general data convert to numeric. | Excel Discussion (Misc queries) | |||
| How do I convert dates mm/dd/yy to general and still look the same | Excel Discussion (Misc queries) | |||
| Convert text date to general number | Excel Discussion (Misc queries) | |||
| Trying to convert hh.mm.ss in General format to minutes | Excel Worksheet Functions | |||
| Changing format of column from "general" to "currency" | Excel Discussion (Misc queries) | |||
Threaded Mode
