Text number to number value for calculating

[ddiebold7]

How do you convert a text number format "51" to number 51 that I can use for calculations. Quotes used to illustrate that it is in text format. Please email me at [email protected]. I am stumped. Please Help!

Dave Diebold

[mangesh_yadav]

=INT("51")

or if cell A1 contains "51", then =INT(A1)


Mangesh

[sanskar_d]

How do you convert a text number format "51" to number 51 that I can use for calculations. Quotes used to illustrate that it is in text format. Please email me at [email protected]. I am stumped. Please Help!

Dave Diebold

Hiiii!

It a very simple trick.
Simply multiply the number (in text format ) by one (in the adjecent cell or column).

[bj]

simce there are often spaces associated with Text numbers I often use
something like
=value(trim(A1))
if the number is in Cell A1

"ddiebold7" wrote:

>
> How do you convert a text number format "51" to number 51 that I can use
> for calculations. Quotes used to illustrate that it is in text format.
> *Please email me at [email protected].* I am stumped. *Please
> Help!*
>
> Dave Diebold
>
>
> --
> ddiebold7
> ------------------------------------------------------------------------
> ddiebold7's Profile: http://www.excelforum.com/member.php...o&userid=24237
> View this thread: http://www.excelforum.com/showthread...hreadid=378475
>
>

[bj]

simce there are often spaces associated with Text numbers I often use
something like
=value(trim(A1))
if the number is in Cell A1

"ddiebold7" wrote:

>
> How do you convert a text number format "51" to number 51 that I can use
> for calculations. Quotes used to illustrate that it is in text format.
> *Please email me at [email protected].* I am stumped. *Please
> Help!*
>
> Dave Diebold
>
>
> --
> ddiebold7
> ------------------------------------------------------------------------
> ddiebold7's Profile: http://www.excelforum.com/member.php...o&userid=24237
> View this thread: http://www.excelforum.com/showthread...hreadid=378475
>
>

[bj]

simce there are often spaces associated with Text numbers I often use
something like
=value(trim(A1))
if the number is in Cell A1

"ddiebold7" wrote:

>
> How do you convert a text number format "51" to number 51 that I can use
> for calculations. Quotes used to illustrate that it is in text format.
> *Please email me at [email protected].* I am stumped. *Please
> Help!*
>
> Dave Diebold
>
>
> --
> ddiebold7
> ------------------------------------------------------------------------
> ddiebold7's Profile: http://www.excelforum.com/member.php...o&userid=24237
> View this thread: http://www.excelforum.com/showthread...hreadid=378475
>
>

[bj]

simce there are often spaces associated with Text numbers I often use
something like
=value(trim(A1))
if the number is in Cell A1

"ddiebold7" wrote:

>
> How do you convert a text number format "51" to number 51 that I can use
> for calculations. Quotes used to illustrate that it is in text format.
> *Please email me at [email protected].* I am stumped. *Please
> Help!*
>
> Dave Diebold
>
>
> --
> ddiebold7
> ------------------------------------------------------------------------
> ddiebold7's Profile: http://www.excelforum.com/member.php...o&userid=24237
> View this thread: http://www.excelforum.com/showthread...hreadid=378475
>
>

[bj]

simce there are often spaces associated with Text numbers I often use
something like
=value(trim(A1))
if the number is in Cell A1

"ddiebold7" wrote:

>
> How do you convert a text number format "51" to number 51 that I can use
> for calculations. Quotes used to illustrate that it is in text format.
> *Please email me at [email protected].* I am stumped. *Please
> Help!*
>
> Dave Diebold
>
>
> --
> ddiebold7
> ------------------------------------------------------------------------
> ddiebold7's Profile: http://www.excelforum.com/member.php...o&userid=24237
> View this thread: http://www.excelforum.com/showthread...hreadid=378475
>
>

[bj]

simce there are often spaces associated with Text numbers I often use
something like
=value(trim(A1))
if the number is in Cell A1

"ddiebold7" wrote:

>
> How do you convert a text number format "51" to number 51 that I can use
> for calculations. Quotes used to illustrate that it is in text format.
> *Please email me at [email protected].* I am stumped. *Please
> Help!*
>
> Dave Diebold
>
>
> --
> ddiebold7
> ------------------------------------------------------------------------
> ddiebold7's Profile: http://www.excelforum.com/member.php...o&userid=24237
> View this thread: http://www.excelforum.com/showthread...hreadid=378475
>
>

[bj]

simce there are often spaces associated with Text numbers I often use
something like
=value(trim(A1))
if the number is in Cell A1

"ddiebold7" wrote:

>
> How do you convert a text number format "51" to number 51 that I can use
> for calculations. Quotes used to illustrate that it is in text format.
> *Please email me at [email protected].* I am stumped. *Please
> Help!*
>
> Dave Diebold
>
>
> --
> ddiebold7
> ------------------------------------------------------------------------
> ddiebold7's Profile: http://www.excelforum.com/member.php...o&userid=24237
> View this thread: http://www.excelforum.com/showthread...hreadid=378475
>
>

[bj]

simce there are often spaces associated with Text numbers I often use
something like
=value(trim(A1))
if the number is in Cell A1

"ddiebold7" wrote:

>
> How do you convert a text number format "51" to number 51 that I can use
> for calculations. Quotes used to illustrate that it is in text format.
> *Please email me at [email protected].* I am stumped. *Please
> Help!*
>
> Dave Diebold
>
>
> --
> ddiebold7
> ------------------------------------------------------------------------
> ddiebold7's Profile: http://www.excelforum.com/member.php...o&userid=24237
> View this thread: http://www.excelforum.com/showthread...hreadid=378475
>
>

[bj]

simce there are often spaces associated with Text numbers I often use
something like
=value(trim(A1))
if the number is in Cell A1

"ddiebold7" wrote:

>
> How do you convert a text number format "51" to number 51 that I can use
> for calculations. Quotes used to illustrate that it is in text format.
> *Please email me at [email protected].* I am stumped. *Please
> Help!*
>
> Dave Diebold
>
>
> --
> ddiebold7
> ------------------------------------------------------------------------
> ddiebold7's Profile: http://www.excelforum.com/member.php...o&userid=24237
> View this thread: http://www.excelforum.com/showthread...hreadid=378475
>
>

[bj]

simce there are often spaces associated with Text numbers I often use
something like
=value(trim(A1))
if the number is in Cell A1

"ddiebold7" wrote:

>
> How do you convert a text number format "51" to number 51 that I can use
> for calculations. Quotes used to illustrate that it is in text format.
> *Please email me at [email protected].* I am stumped. *Please
> Help!*
>
> Dave Diebold
>
>
> --
> ddiebold7
> ------------------------------------------------------------------------
> ddiebold7's Profile: http://www.excelforum.com/member.php...o&userid=24237
> View this thread: http://www.excelforum.com/showthread...hreadid=378475
>
>