View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
craig_100
 
Posts: n/a
Default extract decimal place digit


I have a large table of data which, based on the SUM formulae I have put
in for some columns, apparently have been mis-keyed with 3 decimal
places, instead of only 2. I need to find out which values have 3
decimal places so I can correct them. Suggestions? Will a formula,
using various functions, work? Thanks.


--
craig_100
------------------------------------------------------------------------
craig_100's Profile: http://www.excelforum.com/member.php...o&userid=29187
View this thread: http://www.excelforum.com/showthread...hreadid=489139