fomatting excell cells

[Prashwee]

hello all

I have a problm with currency formats.

Following is done.
I have changed my regional setting to swedish. (currency format is for eg
23.444,99 kr)
Then i have generated a Excel sheet.
I formated cells to display $ with two decimal places.( i want to display
this as $23,444.99)

But when i reload my excell sheet . it did not change the format.
What is the problem with this. Is there any way to get the formated cell
format?

Please help me
/Prash

[prabhupl]

just store that value into an variable. then use the format fiunction

Format(varaiable,"Currency") this is applicable for VBA in Excell