Select the merged cell
Choose Format>Cells
On the Alignment tab, remove the check mark from Merge cells
Click OK
With all the unmerged cells still selected, click in the formula bar
Hold the Ctrl key and press the Enter key.
> Is there a way i can unmerge so that the value goes into all of the cells not
> just the top left cell?

Signature
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html