| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Formating
I am using Excel 2003.
I want to know how to round a whole column of data without using the ROUND(cell,0) formula for each cell in a new column to use the ROUND function to achieve what I want. I have data that has decimal places to 10 or more places when it is imported from different software programs I use; one is from Access. Thanks for your help, Curt |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell Formating
Format Cells... Number and set the number of decimal places to zero.
-- Gary's Student "Curt Hand" wrote: I am using Excel 2003. I want to know how to round a whole column of data without using the ROUND(cell,0) formula for each cell in a new column to use the ROUND function to achieve what I want. I have data that has decimal places to 10 or more places when it is imported from different software programs I use; one is from Access. Thanks for your help, Curt |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell Formating
If you've got such a dislike of the ROUND() function you can format the
original column as number with zero decimal places. If you want to actually change the values you can use Tools/ Options/ Calculation/ Precision as displayed. -- David Biddulph "Curt Hand" wrote in message ... I am using Excel 2003. I want to know how to round a whole column of data without using the ROUND(cell,0) formula for each cell in a new column to use the ROUND function to achieve what I want. I have data that has decimal places to 10 or more places when it is imported from different software programs I use; one is from Access. Thanks for your help, Curt |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell Formating
Thank you.
This is what I was looking for. Curt "David Biddulph" wrote: If you've got such a dislike of the ROUND() function you can format the original column as number with zero decimal places. If you want to actually change the values you can use Tools/ Options/ Calculation/ Precision as displayed. -- David Biddulph "Curt Hand" wrote in message ... I am using Excel 2003. I want to know how to round a whole column of data without using the ROUND(cell,0) formula for each cell in a new column to use the ROUND function to achieve what I want. I have data that has decimal places to 10 or more places when it is imported from different software programs I use; one is from Access. Thanks for your help, Curt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Conditional Formating a cell .. to Show Nothing .. if True | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Cell formating | Excel Discussion (Misc queries) | |||
| conditional formating for a blank cell | Excel Discussion (Misc queries) | |||
Linear Mode
