LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
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
significant digits for decimals Raj Excel Worksheet Functions 7 November 4th 05 01:26 AM
Mistery digits on excel Bewilder Excel Discussion (Misc queries) 2 October 5th 05 06:28 PM
excel floating digits error Bewilder Excel Discussion (Misc queries) 3 October 5th 05 05:56 PM
return significant digits of a cell Chace Excel Worksheet Functions 2 October 1st 05 01:35 PM
How do I increase the of significant digits given in the slope i. mcozbyl Charts and Charting in Excel 2 April 7th 05 12:52 PM


All times are GMT +1. The time now is 07:04 AM.

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

About Us

"It's about Microsoft Excel"