Become a MacRumors Supporter for $25/year with no ads, private forums, and more!

iCloud Numbers

r0k

macrumors 68040
Mar 3, 2008
3,610
73
Detroit
What would be equivalent formula in iCLOUD Numbers from excel formula
=TEXT(A1,"ddmmyyyy")

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...
 

Attachments

  • functions-in-excel-and-numbers-09.pdf
    891.7 KB · Views: 310

campyguy

macrumors 68040
Mar 21, 2014
3,413
953
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".
 

campyguy

macrumors 68040
Mar 21, 2014
3,413
953
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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.