| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,comp.databases.ms-access,microsoft.public.vb
|
|||
|
|||
Excel Formattings
I send data (percentages) to Excel with 1 decimal. The number before
send to excel is 1.2%. When send to Excel the number becomes 1.20%. This is the default setting of Excel for percentages. Can anything be done in order to avoid formatting numbers again in Excel ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Formattings
This statement will insure that your format is the way you
want it: 'After you're data is entered into Cell A1 ActiveSheet.Range("A1").NumberFormat = "0.0%" tod -----Original Message----- I send data (percentages) to Excel with 1 decimal. The number before send to excel is 1.2%. When send to Excel the number becomes 1.20%. This is the default setting of Excel for percentages. Can anything be done in order to avoid formatting numbers again in Excel ? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formattings | Excel Worksheet Functions | |||
Linear Mode
