| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
function or format - remove decimal but retain value
I need to take a column of numbers 1235.36 and change to 123536 with a number
of leading zeros. End result 0000123536. Is there a format or function to accomplish this task? Thanks for any suggestions. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to retain decimal zeroes? | Excel Discussion (Misc queries) | |||
| remove duplicates but retain one not delete both | Excel Discussion (Misc queries) | |||
| Excel: remove cell content but retain formula | Excel Discussion (Misc queries) | |||
| Is there a function or format to remove 'oz' from '12oz' in Excel? | Excel Worksheet Functions | |||
| Increase / decrease decimal - retain cell formatting | Excel Programming | |||
Threaded Mode
