Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I change a number from 700.00 to 70000 without having to re
I would like to be able to convert a list of numbers from the following
formats 900.00, 40.00, 1.00 etc... to the following format 90000, 4000, 100 etc... without having to re-type the numbers. I need to get rid of the decimal point but keep the zeros that are after the decimal point. Is there a function or format that can accomplish this??? Thanks a million for your help!!! |
#2
|
|||
|
|||
The only way to do this would be to change the actual data by multiplying by
100. To do that, you can type the number 100 in a cell, Edit/Copy that cell, then select the numbers to be converted and Edit/Paste Special and select the Multiply and Values options. On Sun, 16 Jan 2005 12:29:02 -0800, "Jennifer" wrote: I would like to be able to convert a list of numbers from the following formats 900.00, 40.00, 1.00 etc... to the following format 90000, 4000, 100 etc... without having to re-type the numbers. I need to get rid of the decimal point but keep the zeros that are after the decimal point. Is there a function or format that can accomplish this??? Thanks a million for your help!!! |
#3
|
|||
|
|||
PS: You can't accomplish this by formatting alone. You must change the actual
data. On Sun, 16 Jan 2005 12:29:02 -0800, "Jennifer" wrote: I would like to be able to convert a list of numbers from the following formats 900.00, 40.00, 1.00 etc... to the following format 90000, 4000, 100 etc... without having to re-type the numbers. I need to get rid of the decimal point but keep the zeros that are after the decimal point. Is there a function or format that can accomplish this??? Thanks a million for your help!!! |
#4
|
|||
|
|||
Hi,
This could help: Custom format: 0"00" ....if it's always .00 Ola Sandström |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change z-axis value from zero to a higher number (eg 4)? | Charts and Charting in Excel | |||
The number change from 1350 to 13.5 and Enter does not function properly | Excel Discussion (Misc queries) | |||
how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) | |||
Change number of columns mid page? | Excel Worksheet Functions | |||
EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions |