fomatting excell cells

  • Thread starter Thread starter Prashwee
  • Start date Start date
P

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
 
just store that value into an variable. then use the format fiunction

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

:)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Currency formatting (Issue with globalization/localization) 2
VBA Currency datatype and NumberFormat 1
Need Macro... 8
Excel Excel 2007 won't stop rounding down my formula results! 5
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Value Rounded when copied from another cell 3
ActiveCell.Value copies unwanted currency format of source cell 15
Auto number formatting 19

Back
Top