I ahve to restrict the exponential format that is displayed for a general format of the cell.I have tried defining custom format for that particualr row .But since i am exporting my data from VB to excel ,i dont know which column it is goign to display my Numeric data .I want to predefine the formatting style ,so that whenevr it opens the excel sheet it should display the custom format for any numeric data
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
how to set Format before Excel file is opened
- Thread starter Priya
- Start date
Excel Facts
Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Similar threads
- Question
- Replies
- 1
- Views
- 264
- Replies
- 4
- Views
- 788
- Replies
- 2
- Views
- 541
- Replies
- 9
- Views
- 639
- Question
- Replies
- 0
- Views
- 960
