1. Jan Kwiatkowski macrumors newbie

    Joined:
    Apr 11, 2014
    #1
    What would be equivalent formula in iCLOUD Numbers from excel formula
    =TEXT(A1,"ddmmyyyy")
     
  2. r0k macrumors 68040

    r0k

    Joined:
    Mar 3, 2008
    Location:
    Detroit
    #2
    I tried this in excel and it produces a string of the form 11042014 (for today) if you put =now() in cell A1. This does not appear to be in Numbers. I checked on my iPad. I also found a pdf online that details functions in excel vs numbers...
     

    Attached Files:

  3. campyguy macrumors 68040

    Joined:
    Mar 21, 2014
    Location:
    Portland / Seattle
    #3
    Not possible (yet) in the iCloud...

    You've set up a "Custom Formatting" situation that's easily addressed in the desktop version of Numbers - but not possible in the iCloud version (yet?). The only means to get that kind of formatting in the iCloud version is to set up a worksheet that has the desired formatting in the desktop app, upload that worksheet to iCloud, then Copy-Paste the cell with the relevant formatting to the desired cell(s) - it's the only workaround I'm aware of for "features not available in the iCloud version".
     
  4. Jan Kwiatkowski thread starter macrumors newbie

    Joined:
    Apr 11, 2014
    #4
    Solution

    Actually I use formula =SUBSTITUTE(A1,"/"."") and it works 100%
     
  5. campyguy macrumors 68040

    Joined:
    Mar 21, 2014
    Location:
    Portland / Seattle
    #5
    Sorry, but IMO you've posed two different issues here, but I won't debate you. It's Friday evening. The result of your OP for the number "1" in Excel would return 01011900 or 01011904, depending on which number system your spreadsheet is based on (1900 or 1904). Any date in Excel is just a number, and =TEXT function returns text, not strings with replaced/inserted characters. The =TEXT and =SUBSTITUTE functions are different functions altogether. Time for a shot of Bushmills... Later.
     

Share This Page