fomatting excell cells
 

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

fomatting excell cells
 

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

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

:)


--
prabhupl
------------------------------------------------------------------------
prabhupl's Profile: http://www.excelforum.com/member.php...o&userid=32468
View this thread: http://www.excelforum.com/showthread...hreadid=522504