Hi Arvi, Thanks for the answer, but i meant that to solve it with formula and
not programming. I want to automate this and not having the user to press any
button

"Arvi Laanemets" wrote:

Hi


"Lp12" wrote in message
...
Thanks a lot Ardus it works perfectly....Do you know of a way without
programming?

Select the cell and press Ctrl+Shift+,


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )