Currency without a $

[Tina]

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 $.

 

[Sheeloo]

Format the cells as CUSTOM with the format
0.00

It will show at least two place after decimal...

If you want thousand separator then use
#,##0.00

 

[Luke M]

Custom format cell as:
#,##0.00

Curious though, why not just set it up as a number with 2 decimal places? Or
is if the red if negative feature you're needing?

Another way might be to go to currency, pick the setting you want (ignore
the $ sign for now), then go to custom. You should the the programmatic way
of displaying the formatting you just choose. Simply delete the $ from the
format, and you should be set.

 

[Tina]

The program we are importing into is Label Matrix...

 

[Tina]

We've tried both your suggestions -- but when we import the file into Label
Matrix (the program we print from) all prices that end with a 0 like 2.50
displays as 2.5

 

[Luke M]

Sounds like a issue with the 2nd program then. You may have to treat it as
text then, and go with the apostrophe use.

OR, if you are using formula, perhaps you can create a helper column, with
formulas that look like
=TEXT(A2,"#,##0.00")
which outputs a text value, whose formatting shouldn't be lost when you send
it to Label Matrix.

 

[Tina]

Problem Solved =TEXT(A2,"#,##0.00") This worked
Thanks Luke M