numeric picture formats
 

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

numeric picture formats
 

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
"Lenny" wrote:

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

numeric picture formats
 

"Lenny" wrote: thank you for replying to my query.... I'll give it a try.
Regards

"FSt1" wrote:

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
"Lenny" wrote:

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