Loosing rounded numbers from PC Excel to Mac Excel

C

CarylJean

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

When I open a PC file that has conditional rounding with three significant figures, on the Mac it shows the numbers all rounded to the nearest one (with no decimals). The PC file has "set precision as displayed" checked.

e.g. 2.61 appears as 3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top