Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am importing an excel file into another program, and them imprinting on an
8-up template. My problem is this - there are $ already pre-printed on our templates. And when we import the excel file it brings it in with $ already in place -- so I end up with two $. I've tried using other formats (or using currency and saying None for the symbol - but it just converts it to number) If we use other formats - we lose the tail end 0 in any numbers that end in 0, like $3.60 becomes 3.6. Is there anyway around this - keeping the currency format - but not the $. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I sum currency values in a row containing currency and uni. | Excel Worksheet Functions | |||
Currency | Excel Discussion (Misc queries) | |||
Currency | Excel Discussion (Misc queries) | |||
Get currency from web | Excel Discussion (Misc queries) | |||
Convert currency to $X.XMM | Excel Discussion (Misc queries) |