iCloud Numbers


r0k

macrumors 68040
Mar 3, 2008
3,612
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

campyguy

macrumors 68040
Mar 21, 2014
3,415
932
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,415
932
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.