Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andy Falkner
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 07:16 PM
Insert row number into a cell? CR Optiker Excel Worksheet Functions 2 January 3rd 06 10:52 PM
Number of characters in a cell (one row, merged columns) Dajana Excel Discussion (Misc queries) 1 September 19th 05 09:30 PM
Help - Any number longer than 12 digits turns to scientific and ro LMH_VT Excel Discussion (Misc queries) 3 July 17th 05 03:58 PM
Count Number of Characters in a cell? AHJuncti Excel Discussion (Misc queries) 2 June 16th 05 07:39 PM


All times are GMT +1. The time now is 07:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"