Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to repalce numbers after a decimal
Lets say I have a column of numbers, that looks like this:
10.242 11.817 12.915 14.805 and I want it to look like this: 10.95 11.95 12.95 14.95 What function could be used to accomplish this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
"Decimal tab" in Excel? | Excel Discussion (Misc queries) | |||
decimal point override does not work | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
finding common numbers in large lists | Excel Worksheet Functions |