LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 139
Default Currency without a $

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I sum currency values in a row containing currency and uni. Eusebius Excel Worksheet Functions 2 November 13th 08 01:35 PM
Currency RHiggs Excel Discussion (Misc queries) 1 November 2nd 06 12:11 AM
Currency kaxx23 Excel Discussion (Misc queries) 1 April 19th 06 05:36 PM
Get currency from web Henrik Excel Discussion (Misc queries) 0 October 17th 05 01:23 PM
Convert currency to $X.XMM StephanieH Excel Discussion (Misc queries) 3 June 13th 05 09:27 PM


All times are GMT +1. The time now is 02:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"