Excel - Number Format

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

  1. haaris954
    Offline

    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
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,659
    Thanks Received:
    2,114
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,484 / 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
    Offline

    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
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,659
    Thanks Received:
    2,114
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,484 / 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
dates show up as $ in excel on ipad
,
excel % showing as decimals in iphone
,
excel date formats appearing on iphone
,
excel date formatting ipad
,
excel date showing up as currency in iphone
,

excel dates appear as numbers iphone

,
excel dates display as numbers on iphone
,

excel dates show as numbers on iphone

,

excel formatting ipad

,
excel formatting on ipad
,

excel show decimals on ipad

,
format data series in excel on ipad
,
format excel on ipad
,

format numbers in excel for ipad

,

how to format phone numbers in excel for iphone

,
ipad does not display excell dates
,

iphone email excel number format wrong

,

iphone excel dates show as numbers

,
why does my ipad not show the correct dates in an excel calendar?
,
why is my email from my ipad showing dates in currency