View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcus
 
Posts: n/a
Default Significant digits

Hello;

I amin dire need of some help. I would like to be able to have a way of
getting the last 2 siginifcant dogits of numeric string in a new cell. i.e.
if a cell contains the number 2.3345 I would like to be able to know what
the last 2 digits are i.e. 45 and have that number show up as in integer in a
new cell. Can anyone help me please.

Thanks.

Mark