Thread: Identifying Numeric Values within a Range Formatted as Text

how to convert number into text (acutal formating)

Eg. : 150500

One Lac Fifty Thousand Five Hundred

like this

please forward me this question answer,

My e mail Account : alex_22@rediffmail.com
S.Alexander

how to convert number into text (acutal formating)

Eg. : 150500

One Lac Fifty Thousand Five Hundred

like this

please forward me this question answer,

My e mail Account : rzkancherla@kanbay.com

Ravikanth

how to convert number into text (acutal formating)

Eg. : 150500

One Lac Fifty Thousand Five Hundred

how to convert number into text (acutal formating)

Eg. : 150500

One Lac Fifty Thousand Five Hundred

like this

please forward me this question answer, i waiting four reply on my email account

My e mail Account : spchoube@rediffmail.com

thanking you,
shreenivas prabhakarrao choube

how to convert number into text (acutal formating)

Eg. : 150500

One Hundred and Fifty Thousand Five Hundred

like this

please forward me the answer to this question,

My e mail Account : poneill@adinet.com.uy
Thks

how to convert number into text (acutal formating)

Eg. : 150500

One Lac Fifty Thousand Five Hundred
Coverting number into text
Ex: 150

One hundred fifty

please forward me the answer to this question,

My e mail Account : fmhjcd@yahoo.com
Thks

To convert number into text (acutal formating)

Eg. : 150500

One Lac Fifty Thousand Five Hundred you will need a add in which converts number to texts which generally doesnt comes with MS excel. Go to ant search engine you will get it.

say 150500 convert to One Lac Fifty Thousand Five Hundred

how to convert number into text (acutal formating)
E.G 1750.50

ONE THOUSAND FIVE HUNDRED & FIFTY
MY EMAIL ID IS belltextiles@batsons.co.in

how to convert number into text

Eg. : 150500

One Lac Fifty Thousand Five Hundred

like this

please forward me this question answer,

My e mail Account : jagdishjoshi01@indiatimes.com

Jagdish Joshi

how to convert number into text

Eg. : 150500

One Lac Fifty Thousand Five Hundred

like this

please forward me this question answer,

My e mail Account : edwin_joseph23@rediffmail.com

edwin joseph

how to convert number into text (acutal formating)

Eg. : 150500

One Lac Fifty Thousand Five Hundred

like this

please forward me this question answer, i waiting four reply on my email account

My e mail Account : pkbasu@slofindia.com

how to convert number into text (acutal formating)

Eg. : 150

One Hundred Fifty Only

like this

please forward me this question answer, i waiting four reply on my email account

My e mail Account : sbwani74@yahoo.co.in

Problem:

Column A contains both numeric and text values, however, all values are formatted as text.
We want to determine which of the values are actually text (i.e. consist of alphabetic characters) and which are only formatted as text, but are in fact numeric.

Solution:

Use the IF and ISERROR functions as shown in the following formula:
=IF(ISERROR(A2+0),\"Text\",\"Number\")

Originally Posted by ali

how to convert number into text (acutal formating)

Eg. : 150500

One Lac Fifty Thousand Five Hundred

Coverting number into text
Ex: 150

One hundred fifty