How do i set a column so that column 'A' is currency?
and things along those lines... thanx
Printable View
How do i set a column so that column 'A' is currency?
and things along those lines... thanx
There is no need to do anything special in Excel such that collumns handle certain types of data.
You can enter numbers anywhere in the worksheet.
To have the numbers appear as currency, highlight the appropriate cells, and from the menu, choose FORMAT, CELLS, CURRENCY. You will be given a choice as to which currency format you want your data to use.
If you want the whole column to format its data using Currency formats, select the Column in its entirety (by clicking on the collumn letter), and then go to FORMAT, CELLS, CURRENCY.
IF you want to do this via code, use the Macro recorder to record the above steps, and pick what you need from the generated code.
thanx im using the recorder...
i had to use it cause of mysql Complications... thanks man!
Newbie to VBA
AznFuman