trimming left digit of a number

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Scott (Scott_at_discussions.microsoft.com)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 13:15:04 -0800

How do I trim the left digit from a number? The user will input a number with
3 digit value and I need to trim the leftmost value from the number. A
typical value might be 123.4567 and I need to remove the 1 and use it's value
in another calculation.
 

Relevant Pages

  • Re: trimming left digit of a number
    ... int value = leftMostChar - '0'; ... > 3 digit value and I need to trim the leftmost value from the number. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: removing spaces
    ... but the data has 2 blank spaces after the last digit and therefore ... I've tried trim, clean and neither are working. ... You may need to precede this with a double unary if this is numeric data, ...
    (microsoft.public.excel.misc)
  • Re: Trimming cell contents?
    ... If you want to hit many groups, do them all in the same message. ... Bob Phillips ... I have a column of cells each containing a 4 digit number. ... way I can trim the left digit dependant upon certain conditions. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: trimming cell contents?
    ... you can use a worksheet function, ... assumimng your number is in A1. ... I can trim the left digit dependant upon certain conditions. ...
    (microsoft.public.excel.programming)
  • Re: trimming cell contents?
    ... Jeremy Turner wrote: ... I can trim the left digit dependant upon certain conditions. ...
    (microsoft.public.excel.programming)