Excel - Number Format

Discussion in 'iPad Help' started by haaris954, May 27, 2011.

  1. haaris954

    haaris954
    Expand Collapse
    iPF Noob

    Joined:
    May 27, 2011
    Messages:
    2
    Thanks Received:
    0
    In excel on my laptop I show the correct value 72 but on my ipad it is showing up as 71,654??

    This is the format I am using on my PC in excel _(* #,##0,_);_(* (#,##0,);_(* "-"_);_(@_) to get 71,654 to show up as 72.

    Ipad shows it as 71,654. Any ideas on what settings I need to change to correct this issue? Thanks.
     
  2. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,415
    Thanks Received:
    4,264
    Numbers doesn't have the same level of formatting control as Excel. There is no way to accomplish this through formatting. The closest you could come would be to create a new column with a formula that devides the first cell by 1000, and format it to display 0 decimal places. The result shoul be the same, but if you use it later for other computations you'll want to use the original cell or remember to multiply by 1000.
     
  3. haaris954

    haaris954
    Expand Collapse
    iPF Noob

    Joined:
    May 27, 2011
    Messages:
    2
    Thanks Received:
    0
    Really? That's no good. :confused: Thanks.
     
  4. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,415
    Thanks Received:
    4,264
    You might try Documents to Go. It has a higher level of compatibility with Excel than Numbers. No gurantee though. No iPad app has all the features of the full program. If you can upload an example sheet someone with DTG might be able to test it for you. Not me, my spreadsheet (compatibility) needs are simple enough that Numbers does the job.
     

Share This Page



Search tags for this page
excel % showing as decimals in iphone
,
excel dates appear as numbers iphone
,
excel dates show as numbers on iphone
,

excel formatting ipad

,
excel show decimals on ipad
,
format numbers in excel for ipad
,
how to format phone numbers in excel for iphone
,
iphone email excel number format wrong
,

iphone excel dates show as numbers

,
why is my email from my ipad showing dates in currency