| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel currency
I have columns of number and need to change that column
to CURRANCY. How can I do that without adding a decimal at the end followed by 2 zeros. Bob B |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel currency
just select the cells/columnright clickformat
cellsnumbercurrencyoptions. -- Don Guillett SalesAid Software "Bob B" wrote in message ... I have columns of number and need to change that column to CURRANCY. How can I do that without adding a decimal at the end followed by 2 zeros. Bob B |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel currency
Bob
Sub Currency_Format() With Selection .NumberFormat = "$#,##0" End With End Sub Gord Dibben Excel MVP On Fri, 9 Jan 2004 07:07:53 -0800, "Bob B" wrote: I have columns of number and need to change that column to CURRANCY. How can I do that without adding a decimal at the end followed by 2 zeros. Bob B |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
| Is there any way of using any currency converter in EXCEL | Excel Discussion (Misc queries) | |||
| how do I sum currency values in a row containing currency and uni. | Excel Worksheet Functions | |||
| Inserting another currency rather than $ on excel | Excel Worksheet Functions | |||
| CURRENCY INDEX FOR EXCEL | Excel Worksheet Functions | |||
Linear Mode
