Excel Magic Trick 454: Get Last Number or Word or Anything 4 Amazing LOOKUP functions

[jonyung06]

i guess the last number is this 452514854545213245541485418541­545151032265454962645654654584­156489456542365654654564654656­418465785474267865495648946546­548454654885454545476565496549­874974578444658683838959527641­672432825324552464658554015554­066565265262967210542814011846­569748901154055454165401654054­054206165054045458545001401251­540154054523510650545054556464­654646540604604106458424102154­054840840545405054555525325832­824561657324655405865721047254­252528557851552542543273245245­542553586386897975

[ALIKALVERT]

i ment do you know how to convert numbers to words automatically

for eg :- i type 4000/- in one cell and it automatically converts it into (four thousand only) in another cell

[ExcelIsFun]

Watch this video:

Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions

Then use NBTEXT

Did you check your add-ins to see if MoreFunc is still added in?

[ALIKALVERT]

i wanted the download to convert number into text eg :- 4420/- convert automatically to

four thousand four hundred & twenty only)

the formula to convert is =nbtext

but since i formated my system i am not able to do it any more

[ExcelIsFun]

I don't know what you mean by "formated my system". Do you check your add-ins to see if MoreFunc is still added in?

[chavan2000]

Hi Sir,

The excel workbook is missing on your site. Hence request you to upload it.

Regards

Heera Chavan

[ExcelIsFun]

I am sorry about that. I have to go to my office to upload it. I am not sure if I will be in on Friday (probably) or not again until Monday...

[ExcelIsFun]

I just uploaded the workbook!