# Formula Help PLEASE. Need to remove the decimal.

#### Mister H

##### Well-known Member
Hi All:

I am looking for the easiest way (formula?) to remove the decimal from a number and have the answer as text.

For Example:

A1 is \$24 500.00 and I want the formula to return 2450000
A2 is \$26 767.98 and I want the answer to be 2676798

How can i accomplish that? I think it is pretty simple but that is the way I am feeling at the moment as well

THANKS,
Mark

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Try

=TEXT(A1*100,"0")

Hi Barry:

THANKS that seems to do the trick. Your assistance is VERY MUCH Appreciated...

Have a GREAT night,
Mark

Added: can you tell me what the "0" represents? I just want to have a better understanding.

Last edited:
In the text function whatever is between the quotes is the formatting, so if you use a formula like

=TEXT(A1,"\$0.00")

then you convert A1 to a text formatted dollar value. "0" formats the number as an integer

THANKS for the explanation Harry

Replies
3
Views
116
Replies
2
Views
330
Replies
6
Views
488
Replies
5
Views
246
Replies
4
Views
313

Threads
1,196,516
Messages
6,015,678
Members
441,915
Latest member
sm Hussaini

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back