| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate using last four digits of number in cell
I need a formula that will calculate the last four digits of a number in a
series of cells. The first five numbers are the same. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate using last four digits of number in cell
=--right(a1,4)
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Andy Falkner" <Andy wrote in message ... I need a formula that will calculate the last four digits of a number in a series of cells. The first five numbers are the same. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate using last four digits of number in cell
try
=RIGHT(E4,4)*2 -- Don Guillett SalesAid Software "Andy Falkner" <Andy wrote in message ... I need a formula that will calculate the last four digits of a number in a series of cells. The first five numbers are the same. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate using last four digits of number in cell
How about an example?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Andy Falkner" <Andy wrote in message ... I need a formula that will calculate the last four digits of a number in a series of cells. The first five numbers are the same. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Insert row number into a cell? | Excel Worksheet Functions | |||
| Number of characters in a cell (one row, merged columns) | Excel Discussion (Misc queries) | |||
| Help - Any number longer than 12 digits turns to scientific and ro | Excel Discussion (Misc queries) | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Linear Mode
