get rid of hyphen in = formula

Hi LO-sages,

I have a spreadsheet which contains a budget scenario. I now want to develop a second scenario with some changed parameters in a second sheet but want both sheets to be connected so that if I change for example the name of some items, they get changed in both sheets.

My way of doing that is very simple, I use = in all cells of the second spreadsheet to simply duplicate the first sheet and copy the format manually. The problem is that this method returns a hyphen for every empty cell. I am sure it is possible to change this but could not find where. Help would be great!

Thanks in advance.

Hey, I just do it using the if command now. =if(a1=""","",a1). Cheers.