| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert numbers
In Column A, the format of the cells is 'number' with 2 decimal-places.
The cells contain: A 1 0.00 2 1024.52 3 3.79 4 7.63 5 1.00 6 6.99 7 512344.56 8 22.42 9 7.03 What formula do I put in column B so the results are nine-digit numbers (without the decimal point)? For example: B 1 000000000 2 000102452 3 000000379 4 000000763 5 000000100 6 000000699 7 051234456 8 000002242 9 000000703 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert numbers to time | Excel Discussion (Misc queries) | |||
| convert letters to numbers | Charts and Charting in Excel | |||
| Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
| Convert text to numbers | Excel Discussion (Misc queries) | |||
| Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions | |||
Threaded Mode
