Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim varying decimals from column of numbers
Good Morning
I am using Excel 2003 and have a column of approximately 250 numbers. Each has different number of decimals. Although the Format displays all as whole numbers, the decimals are be calculated and throowing my cost analysis off when Multplying this column (Quantity) x a Price. How can I trim all values to whole numbers, regardless of their vary number of decimal places. Thanks in Advance Phil |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim varying decimals from column of numbers
the decimals are be calculated
If these numbers are the results of formulas then try something like this: =INT(your_formula_here) -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... Good Morning I am using Excel 2003 and have a column of approximately 250 numbers. Each has different number of decimals. Although the Format displays all as whole numbers, the decimals are be calculated and throowing my cost analysis off when Multplying this column (Quantity) x a Price. How can I trim all values to whole numbers, regardless of their vary number of decimal places. Thanks in Advance Phil |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim varying decimals from column of numbers
You could try =DOLLAR(cell,#) where #=number of decimals.
"T. Valko" wrote: the decimals are be calculated If these numbers are the results of formulas then try something like this: =INT(your_formula_here) -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... Good Morning I am using Excel 2003 and have a column of approximately 250 numbers. Each has different number of decimals. Although the Format displays all as whole numbers, the decimals are be calculated and throowing my cost analysis off when Multplying this column (Quantity) x a Price. How can I trim all values to whole numbers, regardless of their vary number of decimal places. Thanks in Advance Phil . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim varying decimals from column of numbers
Forgot...use Ctrl+Enter after typing the formula.
"Nadine" wrote: You could try =DOLLAR(cell,#) where #=number of decimals. "T. Valko" wrote: the decimals are be calculated If these numbers are the results of formulas then try something like this: =INT(your_formula_here) -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... Good Morning I am using Excel 2003 and have a column of approximately 250 numbers. Each has different number of decimals. Although the Format displays all as whole numbers, the decimals are be calculated and throowing my cost analysis off when Multplying this column (Quantity) x a Price. How can I trim all values to whole numbers, regardless of their vary number of decimal places. Thanks in Advance Phil . |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim varying decimals from column of numbers
The problem with this is that the decimals vary. Somne show 3 decimals, while
others shor 4 ot 5 decimals. "Nadine" wrote: Forgot...use Ctrl+Enter after typing the formula. "Nadine" wrote: You could try =DOLLAR(cell,#) where #=number of decimals. "T. Valko" wrote: the decimals are be calculated If these numbers are the results of formulas then try something like this: =INT(your_formula_here) -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... Good Morning I am using Excel 2003 and have a column of approximately 250 numbers. Each has different number of decimals. Although the Format displays all as whole numbers, the decimals are be calculated and throowing my cost analysis off when Multplying this column (Quantity) x a Price. How can I trim all values to whole numbers, regardless of their vary number of decimal places. Thanks in Advance Phil . |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim varying decimals from column of numbers
Did you try my suggestion?
-- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... The problem with this is that the decimals vary. Somne show 3 decimals, while others shor 4 ot 5 decimals. "Nadine" wrote: Forgot...use Ctrl+Enter after typing the formula. "Nadine" wrote: You could try =DOLLAR(cell,#) where #=number of decimals. "T. Valko" wrote: the decimals are be calculated If these numbers are the results of formulas then try something like this: =INT(your_formula_here) -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... Good Morning I am using Excel 2003 and have a column of approximately 250 numbers. Each has different number of decimals. Although the Format displays all as whole numbers, the decimals are be calculated and throowing my cost analysis off when Multplying this column (Quantity) x a Price. How can I trim all values to whole numbers, regardless of their vary number of decimal places. Thanks in Advance Phil . |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim varying decimals from column of numbers
There is no formulae. The numbers aparently came over from another
spreadsheet as values withb the decimals alreaddy there. "T. Valko" wrote: Did you try my suggestion? -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... The problem with this is that the decimals vary. Somne show 3 decimals, while others shor 4 ot 5 decimals. "Nadine" wrote: Forgot...use Ctrl+Enter after typing the formula. "Nadine" wrote: You could try =DOLLAR(cell,#) where #=number of decimals. "T. Valko" wrote: the decimals are be calculated If these numbers are the results of formulas then try something like this: =INT(your_formula_here) -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... Good Morning I am using Excel 2003 and have a column of approximately 250 numbers. Each has different number of decimals. Although the Format displays all as whole numbers, the decimals are be calculated and throowing my cost analysis off when Multplying this column (Quantity) x a Price. How can I trim all values to whole numbers, regardless of their vary number of decimal places. Thanks in Advance Phil . . |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim varying decimals from column of numbers
Ok, let's assume your numbers are in the range A2:A100. Enter this formula
in B2 and copy down as needed: =INT(A2) -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... There is no formulae. The numbers aparently came over from another spreadsheet as values withb the decimals alreaddy there. "T. Valko" wrote: Did you try my suggestion? -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... The problem with this is that the decimals vary. Somne show 3 decimals, while others shor 4 ot 5 decimals. "Nadine" wrote: Forgot...use Ctrl+Enter after typing the formula. "Nadine" wrote: You could try =DOLLAR(cell,#) where #=number of decimals. "T. Valko" wrote: the decimals are be calculated If these numbers are the results of formulas then try something like this: =INT(your_formula_here) -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... Good Morning I am using Excel 2003 and have a column of approximately 250 numbers. Each has different number of decimals. Although the Format displays all as whole numbers, the decimals are be calculated and throowing my cost analysis off when Multplying this column (Quantity) x a Price. How can I trim all values to whole numbers, regardless of their vary number of decimal places. Thanks in Advance Phil . . |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim varying decimals from column of numbers
Thanks that works. Can we add anything to it that would round up at = .5
and down at <= .4 "T. Valko" wrote: Ok, let's assume your numbers are in the range A2:A100. Enter this formula in B2 and copy down as needed: =INT(A2) -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... There is no formulae. The numbers aparently came over from another spreadsheet as values withb the decimals alreaddy there. "T. Valko" wrote: Did you try my suggestion? -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... The problem with this is that the decimals vary. Somne show 3 decimals, while others shor 4 ot 5 decimals. "Nadine" wrote: Forgot...use Ctrl+Enter after typing the formula. "Nadine" wrote: You could try =DOLLAR(cell,#) where #=number of decimals. "T. Valko" wrote: the decimals are be calculated If these numbers are the results of formulas then try something like this: =INT(your_formula_here) -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... Good Morning I am using Excel 2003 and have a column of approximately 250 numbers. Each has different number of decimals. Although the Format displays all as whole numbers, the decimals are be calculated and throowing my cost analysis off when Multplying this column (Quantity) x a Price. How can I trim all values to whole numbers, regardless of their vary number of decimal places. Thanks in Advance Phil . . . |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trim varying decimals from column of numbers
Use the round function...
=ROUND(A1,n) Where n is the number of decimal places to round to. A1 = 49.537 =ROUND(A1,2) = 49.54 =ROUND(A1,1) = 49.5 =ROUND(A1,0) = 50 -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... Thanks that works. Can we add anything to it that would round up at = .5 and down at <= .4 "T. Valko" wrote: Ok, let's assume your numbers are in the range A2:A100. Enter this formula in B2 and copy down as needed: =INT(A2) -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... There is no formulae. The numbers aparently came over from another spreadsheet as values withb the decimals alreaddy there. "T. Valko" wrote: Did you try my suggestion? -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... The problem with this is that the decimals vary. Somne show 3 decimals, while others shor 4 ot 5 decimals. "Nadine" wrote: Forgot...use Ctrl+Enter after typing the formula. "Nadine" wrote: You could try =DOLLAR(cell,#) where #=number of decimals. "T. Valko" wrote: the decimals are be calculated If these numbers are the results of formulas then try something like this: =INT(your_formula_here) -- Biff Microsoft Excel MVP "AuthorizedUserPF" wrote in message ... Good Morning I am using Excel 2003 and have a column of approximately 250 numbers. Each has different number of decimals. Although the Format displays all as whole numbers, the decimals are be calculated and throowing my cost analysis off when Multplying this column (Quantity) x a Price. How can I trim all values to whole numbers, regardless of their vary number of decimal places. Thanks in Advance Phil . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto fill column with sequential numbers with decimals | Excel Discussion (Misc queries) | |||
Trim Numbers | Excel Discussion (Misc queries) | |||
How do I retain the format of varying numbers in Excel? | Excel Discussion (Misc queries) | |||
linking one column or varying range to another column using same f | Excel Worksheet Functions | |||
Varying column width in a column chart | Charts and Charting in Excel |