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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to repalce numbers after a decimal
Format-Cells-Number tab-Click 'Custom', and enter this:
0.95 -- Regards, Dave "dpscoupe" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to repalce numbers after a decimal
One way:
=INT(A1)+0.95 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "dpscoupe" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to repalce numbers after a decimal
Try this:
Select the range of values EditReplace Find what: .* Replace with: .95 Click [Replace All] Does that help? *********** Regards, Ron "dpscoupe" wrote: 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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to repalce numbers after a decimal
Thanks! Got it licked now!
"RagDyeR" wrote: One way: =INT(A1)+0.95 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "dpscoupe" wrote in message ... 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? |
Reply |
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 |