I want the "my places" customizations made in Word in the Open and Save as everytime it appears in ALL office software. For instance, in Outlook when I insert a file to attach, etc. -- S
I want the "my places" customizations made in Word in the Open and Save as everytime it appears in ALL office software. For instance, in Outlook when I insert a file to attach, etc. -- S
Does anyone have any experience with the order of the "My Places" shortcuts resequencing themselves on their own in Office XP? How can I prevent it from happening?
1.Outlook places comma in wrong place for some contacts
I have searched this forum and the MS knowlegebase and can not find a answer to my problem. Occasionally, Outlook will place the comma in the wrong place for a contact in the "file as" box. If I enter Jim Smith, it sometimes appears in the "file as" box as Jim, Smith. I have the preferences set to sort by last name. This problem only occurs occasionally. When it does occur, I am unable to edit the contact in order to fix it. In fact, today I deleted the contact and re-entered it but it still was displayed as Jim, Smith. Any ideas? -- Eric H
2.decimal places in acces more than 2 places when importing an excel
I have saved a csv file in excel then imported it to access however when I run a sum values query the value it brings back is ie. 120.965394000. which is more than two decimal places. I have changed the format in excel and the field propeties in access and the poblem is still there. When I return to excel the and format numbers with 30 decimal places the values shown are ie 120.9700000000 etc. but when I sum up the column it brings me back ie.587.0001. basically how can I only import values with 2 decimal places in access from excel when the original data maybe far more then 2 decimal places. Please help me thanks. Robert
3.decimal places in acces more than 2 places when importing an e
Unfortunately their are not more 30 decimal places in excel when viewing a CSV file and the numbers only appear as 120.000000000000000etc. I have opened the CSV file in note pad and again there are only 1 to 2 decimal places. however if I auto sum the column the value would be 5700.950000010000etc. by highlighting row by row using the auto sum at the bottom of the screen I can see when the decimal places are more than 2 however the value in question still shows two decimal places. The data is very large and I would like to round all values down to 2 decimal places easily before importing. Thanks "dlw" wrote: > What does the number in the CSV file look like? You probably need to > =round() before importing. Changing the format does nothing to the number, > it just changes how it is displayed. > > "robertrobertrobertrobert" wrote: > > > I have saved a csv file in excel then imported it to access however when I > > run a sum values query the value it brings back is ie. 120.965394000. which > > is more than two decimal places. > > I have changed the format in excel and the field propeties in access and the > > poblem is still there. When I return to excel the and format numbers with 30 > > decimal places the values shown are ie 120.9700000000 etc. but when I sum up > > the column it brings me back ie.587.0001. basically how can I only import > > values with 2 decimal places in access from excel when the original data > > maybe far more then 2 decimal places. > > > > Please help me thanks. > > > > Robert
4.Formatting to 2 decimal places, placing a page break and autofitting a collumn/row height
5.Formatting to 2 decimal places, placing a page break and autofitti
6. Highest & lowest place value / decimal places of cell value
Users browsing this forum: No registered users and 5 guest