| 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!!! |
| 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 | |||
Threaded Mode
