$$Excel-Macros$$ Re: excel help me

2018-01-06 Thread who
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

Re: $$Excel-Macros$$ excel help me

2018-01-06 Thread Mangesh Vimay
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?

$$Excel-Macros$$ excel help me

2018-01-06 Thread Deepu Raj
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