Excel - Number Format

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

  1. haaris954

    haaris954 iPF Noob

    Joined:
    May 27, 2011
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Chicago
    Ratings:
    +0 / 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 iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,289
    Thanks Received:
    2,472
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +3,031 / 1
    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 iPF Noob

    Joined:
    May 27, 2011
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Chicago
    Ratings:
    +0 / 0
    Really? That's no good. :confused: Thanks.
     
  4. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,289
    Thanks Received:
    2,472
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +3,031 / 1
    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 dates appear as numbers iphone
,
excel dates show as numbers on iphone
,

excel formatting ipad

,
excel show decimals on ipad
,
format decimals excel iphone
,
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

,
multiply by 1000 excel number format