Problem with exel file on a Mac

[B_2]

Hi

Got an exel file which opens fine but when opening this file on a Mac i get a load of hash signs in a few cells

the cells in question have formula's such as;

=IF(COLUMN(G13)-4=$B13,$D13-$J13,0)

Does anyone know what is going on?

Thanks

 

[FinancialAnalystKid]

Hash signs? What's that?

Maybe the column width needs to be extended?

 

[B_2]

that worked i did not try that as the columns seemed more
than large enough.

Hash sign = the hash key on a mobile

Thanks