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?

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?

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?

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?

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?