Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL2007 French Numeric Formats | Excel Discussion (Misc queries) | |||
PICTURE RECOGNITION AS A ALPHA-NUMERIC CHARACTER | Excel Worksheet Functions | |||
numeric cell formats | Excel Discussion (Misc queries) | |||
French numeric formats | Excel Discussion (Misc queries) | |||
Numeric formats | Excel Programming |