Fixed Decimal in Excel

  • Thread starter Thread starter ms
  • Start date Start date
M

ms

I have a spreadsheet that requires a password to make
corrections and it's on a shared drive so a couple of
people can access it. A co-worker set up a spreadsheet on
her local drive, went into tools, options, edit and
checked off the fixed decimal box and chose 2 decimal
places. When I opened my spreadsheet, the change she made
for the two decimal places also affected my spreadsheet.
This doesn't make sense to me -- especially since I have a
password on mine. Is this scenario familiar to anyone?
Thanks!
 
Back
Top