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

--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"Tina" wrote:

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