numeric picture formats

  • Thread starter Thread starter Lenny
  • Start date Start date
L

Lenny

I have to compute euros.

Cell A Cell B = Cell C
3 10 000,00 30 000,00

Since the formatting for european money looks much different from US
currency. What would the formula look like. Someone mentioned that vb
doesn't accept the spaces... in that case, what do I need to do to get the
cells to compute correctly.
Assistance is always greatly appreciated.
Lenny
 
hi
you could use a custom format for display purposes only and let excel do the
math in the background and not worry about vb not handling the spaces.
highlight the area to format, right click the area and from the popup, click
format cells
on the format dialog, click number tab. in the catagory box, click custom
and enter this in the type: box

## ##0.00

you will see 30 000.00 on the sheet but 30000 will be in the formula bar.

regards
FSt1
 
Back
Top