If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do you remove the decimal point in a number?
If you have 124.70 in a cell is there a way to remove the decimal point and
show it as 12470? |
#2
|
|||
|
|||
How do you remove the decimal point in a number?
On Fri, 6 Aug 2004 12:51:04 -0700, carter
wrote: If you have 124.70 in a cell is there a way to remove the decimal point and show it as 12470? Multiply by 100 124.70 * 100 = 12470 --ron |
#3
|
|||
|
|||
How do you remove the decimal point in a number?
Da, that will work, thanks! Not exactly what I was thinking of, but if it
orks it works! Thanks again! "Ron Rosenfeld" wrote: On Fri, 6 Aug 2004 12:51:04 -0700, carter wrote: If you have 124.70 in a cell is there a way to remove the decimal point and show it as 12470? Multiply by 100 124.70 * 100 = 12470 --ron |
#4
|
|||
|
|||
How do you remove the decimal point in a number?
On Fri, 6 Aug 2004 13:19:02 -0700, carter
wrote: Da, that will work, thanks! Not exactly what I was thinking of, but if it orks it works! Thanks again! "Ron Rosenfeld" wrote: On Fri, 6 Aug 2004 12:51:04 -0700, carter wrote: If you have 124.70 in a cell is there a way to remove the decimal point and show it as 12470? Multiply by 100 124.70 * 100 = 12470 --ron Sometimes the simple things are not so obvious :-) Thanks for the followup. --ron |
#5
|
|||
|
|||
How do you remove the decimal point in a number?
for an unknown # of places to the right of the decimal point try
=10^(LEN(A1)-SEARCH(".",A1))*A1 assuming your # is in cell a1 --- Message posted from http://www.ExcelForum.com/ |
#6
|
|||
|
|||
How do you remove the decimal point in a number?
On Fri, 6 Aug 2004 21:08:31 -0500, duane
wrote: for an unknown # of places to the right of the decimal point try =10^(LEN(A1)-SEARCH(".",A1))*A1 assuming your # is in cell a1 Of course, that formula will give an error if there are no places to the right of the decimal point. Another formula that works would be: =A1*10^(-1+MATCH(TRUE,A1*10^(-1+ROW(INDIRECT("1:16"))) =INT(A1*10^(-1+ROW(INDIRECT("1:16")))),0)) entered as an *array* formula. --ron |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2003 & Fixed Decimal Places | Aless | Setting up and Configuration | 3 | October 25th, 2004 05:26 PM |
Default new open files to 2 decimal places | Setting up and Configuration | 5 | June 21st, 2004 04:26 AM | |
completely delete office2000 | jason | Setup, Installing & Configuration | 1 | May 28th, 2004 10:08 AM |
Decimal Point Separator | Mark | Setting up and Configuration | 1 | March 19th, 2004 06:16 PM |