I use office 08 for excel. Some of the boxes I use are formatted so when I enter the date say 22feb hit enter, it corrects it to read Feb. 22. When I import into numbers, and try to do it, there is no format for that cell, I type 22feb, and that s what shows in the cell, Is there a way of formatting these to do the way the excel spreedsheet works?
View 2 Replies
Every time I change the cell format in numbers, it keeps going back to 12/30/11 when I want 2/1/12. It is quite frustrating because I did what it said to do.
View 2 Replies View Relatedhow to change india numbers to arabic numbers?
Info:
MacBook
Pro, Mac OS X (10.6.7)
I am on Tiger 10.4.11 on Mac Book Pro Intel duo. All updates except for Parallels installed. Have run permissions repairs and preferential treatment. Tried to delete preferences for system ... Every time I try to uncheck the box marked or open the Date and Time preferences, it freezes and have to force quit.
I am wondering if there is a way to take an excel spreadsheet in numbers and change the format to alphabetical - the person did the list by DOB and that is just not helpful to me in finding clients?
Info:
iMac, Mac OS X (10.6.8)
SL has this new feature where you can display the date in the menu bar beside the clock. However, it shows my date as "Oct 27" even though I set my date format as "27 Oct". Is there any way to change this?
View 5 Replies View RelatedI know how to insert the date and time, but I need it to automatically put it in the format of Month/Date/Year (ie August 3, 2009). When your insert the date and time in Pages, it automatically puts it in the format of Day/Month/Date/Year (ie Monday, August 3, 2009). I know if you right click on it and select "Edit Date and Time" you can adjust the format, but I need it to automatically put it in the format I want (Month/Date/Year) when I select "Insert Date and Time."
View 3 Replies View RelatedHow do I set a custom time & date format in the top bar?Â
When I go to System Preferences > Language & Text > Formats I can set different formats. I have no idea where you will see these, but I know that it's not the top bar where the time and date is being displayed. Because no matter what I enter, the format in the top bar will stay the same. I can only choose things like 24-Hour clock or not, blinking dots and so on in the Time & Date settings from the System Preferences.Â
Info:
iMac, Mac OS X (10.7.3)
I have found a previous conversation, see community converation titled:Â Label Y-Axis as letters, not numbers?
it describes how to do what I want. I understand this described process but I cannot figure out where to place the "lookup" formula for it to work. Do I select the whole table, one column, etc. I have tried to recreate the screen shot sample but get stumped at the formula placement. I need to graph reading levels from a-z with the y-axis being letters not numbers and this old conversation has created this. I have been searching the web for 4 hours and got no where until I found this discussion and now I am so close...
Info:
excel, charts, Mac OS X (10.6.8)
I need to change the date on some of my photos in iPhoto. Some of them are from a disc of old (non-digital camera) photos and are all dated 1/1/99. I'd like to put them in some sort of date order. Also my girlfriend set the date on her new camera/phone to be 2008 so I'd like to change those too. I've got iPhoto 6 if that helps.
View 9 Replies View RelatedI have been changing all of my icons by downloading different ones online, I am wondering how I can download an ical icon and have it change with date.
View 1 Replies View RelatedMy girlfriend and I have been sharing her Kodak camera for a while now. We use it to take family photos and such. I then use iPhoto to import the photos and break them up into events. Well, I let my girlfriend use the camera about 3 months ago and she changed the time stamp of the photos to 2008 instead of 2009 somehow. I sat down about a week ago to import all the photos we had since taken and was shocked when iPhoto put the new events way back with events from 2008. I then realized the time stamp was off and about had a fit. I quickly rectified the problem on the camera so this will no longer be an issue, but we have tons of great photos which are all incorrectly dated.
And call me a perfectionist, but its driving me nuts!! Now whenever I'm showing friends and family photos I have to scroll way back to 2008, and its just not fluid. I have tried quite a few things to change the date stamp. I cant seem to find any options in iPhoto, so I went into finder and opened the "Get Info" pain to see if I could manually change it, but no dice. I've googled for a week now and cant seem to find an answer. Does anyone know of some software that can handle this or a trick im overlooking? (Just to clarify, by date stamp, im not referring to the date image ingrained on the picture itself, but rather the date the camera assigns to the image file.)
I am on Tiger 10.4.11 on Mac Book Pro Intel duo. All updates except for Parallels installed. Have run permissions repairs and preferential treatment. Tried to delete preferences for system ...
Every time I try to uncheck the box marked or open the Date and Time preferences, it freezes and have to force quit.
I have files with no creation date or creation date 1969, etc (came from bad settings in camera).
Since I knew the date, I was able to easily fix it via touch:
touch -t 20090110 IMG_1023.JPGÂ
This used to set creation, modification, and access time to 20090111, in Snow Leopard.  However, I can no longer do this in Lion. It does set modification and access, but creation date is still screwed up.Â
Info:
macbook pro 2007, Mac OS X (10.7.2), iPhone 3GS, 4, iPad2, latest iOS5
It seems that whenever you open a nested folder in the finder, it changes the modification date of the parent directory, this is a real pain, especially in the nested folders of the ~/Library folder. I often trawl through these folders in search of Application Support files etc and don't necessarily want the parent folder's modification date to change just 'cos I view its contents. This happens regardless of whether I have modified the contents or not!
View 7 Replies View RelatedWhen you click on any folder on the desktop and you click the gear icon and go to the "Arrange by" option and select "Date created", it puts the newest items toward the beginning of the folder. Is there any way to change that so the older items are at the top and the newer are at the bottom?
Info:
MacBook, Mac OS X (10.6.1)
My computer's clock is set to a date before Jan 1, 2008. Its not allowing me to go back into Date & Time to change. What do i do?
View 3 Replies View RelatedNormally, a Folder "Date Modified" does not change unless the folder itself changes (name, etc). Is it possible to "force" a Folder "Date Modified" timestamp to change when an enclosed file is changed/updated? I want to look at a folder and know the date/time of the latest enclosed file/folder change. This is especially important to me when using syncing apps as I want to visually see by a folders date that a sync has occurred (the actual file change may be deeply nested within the folder.)
View 1 Replies View RelatedI have an external HDD with ~40 GB of data (~200 GB free) and my internal HDD only has 25 GB free. How is it possible that I could resize the HFS+ partition and add a FAT partition to the external drive without losing any data (like Disk Utility will do)?
View 5 Replies View RelatediPhoto will not import a video on my kodak camera but it will import photos. The only difference I can really tell between this movie and others I already have imported into iPhoto are that this one is a .MOV file and the others are .MPG files. Anyway to change this? In the camera maybe? I can't open the file in quicktime either, no way to access it I think since it cant import.
View 18 Replies View RelatedI'm using Leopard. Is there a way to change screenshots so they don't save as png? Say maybe gif or jpeg? I googled, but all the ways I've found require extra software or terminal. Is there an easier way?
View 6 Replies View RelatedI could have sworn that, somewhere, it's possible to select whether screen grab saves as PNG, JPEG etc. I can't find that option anywhere now. I know you can convert it in Preview, but that's no good. Am I losing my mind??
View 2 Replies View Relatedhow do you change the format of a file.
Info:
iMac
how to change the usb windows format to mac format
Info:
MacBook Pro
How do I change the format of an email
Info:
iMac, Mac OS X (10.7.4)
How do I change screenshot format to jpg instead of png. The old terminal comand does't work on 10.10.1 anymore.
Info:
Aperture 3, OS X Yosemite (10.10)
Is there a way to change the default file format for Grab? Who uses .tiff anyway!?
View 14 Replies View RelatedMy iTunes playlists used to give a precise total play time. Now that I downloaded the new version of iTunes, the playlist just estimates the time. So, "1 hour" could mean 1 hour and 2 or 3 or 4 minutes. That is a big problem for people who teach 60-minute fitness classes! I plan my class around that playlist, and 3 or 4 minutes is a big deal. Now I am having to add up the time of songs by hand. What a pain! Is there any way to get back the old format of time, which estimated exactly "59 minutes" or I think it was more precise, like "00:59:12." I need this format back. The estimate of "1.1 hours" is killing me.
Info:
MacBook, Mac OS X (10.5.8)
my wife was backing up her photos to our USB stick when suddenly she gets this warning...Just before she had been trying to copy some photos, but the computer didn't allow that, probably some photos were corrupted. I however found those photos on the USB stick, but they are grayed out.I can still open everything else on the stick, and copy from the stick to the desktop, but I can't delete those photos from the stick, trash simply says they can't be deleted. So I decided to simply reformat the stick. However, when I try and erase it, I get this warning
I cannot verify the permissions nor the disk, and I can't repair either, the tabs are simply grayed out. So I decided to check on the permissions on the stick, and suddenly it is in read-only mode, and I can't change it. The lock on the bottom and the droptab won't appear..I tried using google to find a solution and someone pointed out a terminal command, but everything there seemed in order.. I suddenly can only read the Volume, and nothing else, and I can't format nor repair it! I bought this stick very recently, and I want to try everything before I pick up my wallet for a new one! The problem started on my wifes 2012 MacBook Air, and still persists on my late 2011 MacBook Pro. We both have Mavericks.
Info:
MacBook Pro (13-inch Late 2011), OS X Mavericks (10.9.4)
Every question I see about changing the screenshot format here seems overly complicated, or requires installing another app.Â
I'm pretty sure screenshots used to always be png, but I just noticed that they are now jpeg. I do a lot of graphics work and want to capture as png.Â
Here there are instructions for code in Terminal. Is that really necessary? Shouldn't it just be a preference somewhere? (I will always use cmd+shift+4 to take the screenshots)
Info:
MacBook Pro, Mac OS X (10.6.8)
