References omit formatting and return cell address - not data

[MZ]

In two cases of references between worksheets, the formatting from the
original cell does not appear in the cell that it is referenced to.

Case 1:
Worksheet 1, A1 contains a currency formatted number - $2,000
Worksheet 2, A1 references the Workhseet 1, A1 cell using the = sign, yet it
returns 2000 (unless I manually reformat the Workksheet 2 cell to Currency


Case 2:
Worksheet 3, A1 contains an apartment # - e.g. 4
Worksheet 4, A1 references this cell but returns the cell address -
Worksheet2,!A1' - rather than the number 4. I tried different formats for the
number 4, including =TEXT, but it did not correct the problem.

Thank you

 

[Arceedee]

Case 1
Sheets 1 & 2 in col a will have to be formatted as currency but you only
need do this the once.

Case 2
Check your inputs.