On Saturday, January 6, 2018 at 7:55:55 AM UTC-8, Deepu Raj wrote:
>
> how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing
> using excel
>
It has already been suggested to use the RIGHT function, but also use the
VALUE function. Assuming the number is in A1 the
formula
You can use left or right function by converting number to text..
On Jan 6, 2018 21:26, "Deepu Raj" wrote:
> how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing
> using excel
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing
using excel
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use