OS X :: How To Change Date Format In Numbers

Feb 21, 2009

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?

ADVERTISEMENT

OS X V10.6 Snow Leopard :: Unable To Change The Format In Cells In Numbers?

Jan 31, 2012

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 Related

MacBook Pro :: Change India Numbers To Arabic Numbers?

May 22, 2012

how to change india numbers to arabic numbers?

Info:
MacBook
Pro, Mac OS X (10.6.7)

View 3 Replies View Related

Software :: Unable To Change Date And Time Settings / Date And Time Preferences Freezes

May 22, 2008

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.

View 23 Replies View Related

OS X V10.6 Snow Leopard :: Format Numbers Into Alphabetical List?

May 31, 2012

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)

View 1 Replies View Related

OS X :: Changing SL Date Format In Menu Bar

Oct 26, 2009

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 Related

OS X :: Automatically Put Custom Date Format In Pages

Aug 3, 2009

I 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 Related

Intel Mac :: Set A Custom Time & Date Format In The Top Bar?

May 20, 2012

How 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)

View 4 Replies View Related

MacBook :: How To Change Y Axis Numbers To Letters

Jun 16, 2012

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)

View 1 Replies View Related

OS X :: How To Change Date Of Photos In IPhoto

Nov 18, 2007

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 Related

OS X :: How To Download ICal Icon And Change It With Date

Oct 3, 2009

I 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 Related

Applications :: How To Change Date Stamp On Photos

Oct 12, 2009

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

View 6 Replies View Related

Software :: Cannot Change Date & Time Settings?

Mar 31, 2009

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.

View 2 Replies View Related

OS X V10.7 Lion :: Cannot Change File Creation Date

Feb 12, 2012

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

View 7 Replies View Related

Software :: Change Of Modification Date On Opening Nested Folder

Nov 8, 2008

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 Related

OS X :: Change Format Of Partition?

Feb 10, 2009

I 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 Related

OS X :: Possible To Change MOV File Format To MPG?

Mar 12, 2009

iPhoto 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 Related

OS X V10.7 Lion :: Force Folder Date Modified To Change When Enclosed File Updates?

Jun 19, 2012

Normally, 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 Related

OS X :: How To Change The Format A Screenshot Saves As?

May 6, 2009

I'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 Related

OS X :: Change Format Of Screen Grab?

Sep 25, 2009

I 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 Related

IMac PPC :: Change The Format On A File?

Apr 5, 2012

how do you change the format of a file.

Info:
iMac

View 5 Replies View Related

MacBook Pro :: Change The Format Of The Usb Windows To It?

Jun 6, 2012

how to change the usb windows format to mac format

Info:
MacBook Pro

View 1 Replies View Related

OS X V10.7 Lion :: How To Change The Format Of An Email

Jun 6, 2012

How do I change the format of an email

Info:
iMac, Mac OS X (10.7.4)

View 1 Replies View Related

OS X :: Way To Change The Default File Format For Grab ?

Jan 23, 2007

Is there a way to change the default file format for Grab? Who uses .tiff anyway!?

View 14 Replies View Related

ITunes :: Why Did The Playlist Time Format Change In 10.6

Apr 1, 2012

My 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)

View 4 Replies View Related

Applications :: How Do I Fill A Column With Numbers And Equations Automatically In Numbers

Jul 17, 2010

I've been ripping my hair out trying to find the answer to this.

In Numbers for Mac, I need to fill a column automatically with a series of integers (1 - 50) and then the next column with a function that interacts with the first column.

For example:

Column A - 1 - 5

Column B - (value in Column A * 5)

I can't figure out how to do it in Numbers When I try to fill column a with 1 - 50 all it does is fill all 1's and I cant find an option how to make that change so it automatically numbers when I highlight them.

The best I can describe is how in Excel you can type 1 in the first cell, then highlight a bunch of cells and the little box appears that lets you click "Fill Series"

View 1 Replies View Related

OS X V10.6 Snow Leopard :: How To Change Screen Shot Format

Apr 5, 2012

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)

View 4 Replies View Related

Applications :: Input Numbers In Numbers As Degrees Instead Of Radians?

Mar 24, 2009

See above title. i get that there's the "degree(cell)" function, but there has to be an easier way to change the settings so you can just input in degrees rather than radians.

like how calculators have a degrees and radians mode, i find it so hard to believe that there isn't one in numbers. if there really isn't, this is an incredibly flawed program.

View 3 Replies View Related

OS X V10.6 Snow Leopard :: Change The File Format Of A Dragged And Dropped Image

Jun 15, 2012

I am dragging and dropping a logo into Mail.app signature pane. The image is saved as a jpg, when I drag into the mail signature pane it's file name is 'PastedGraphic.tiff'. I am assuming there is file format preference somewhere that can keep the image either it's original format, or convert to a jpg, vs. a .tif 

Most other email clients won't display this format. .

Info:
Mac Pro, Mac OS X (10.6.8)

View 6 Replies View Related

OS X :: Sort By The Date A File Is Placed Into A Folder (Date Modified/Created Not Working)

Jun 3, 2010

I have a folder where I place an ever growing collection of my favorite songs. Before I switched to Mac, on Windows, when I wanted to revisit songs I most recently added to the folder, I would sort the songs by the Date Modified and it would order the files I placed in the folder by date.

In OSX, however, there must be a slightly different meaning to "Date Modified," as it does not quite sort my songs by the order they were added. It gets some of it right, but there's plenty of files that are out of order--tune "x", which I know was placed in the folder a week ago is actually listed further down the list with songs placed in the folder months ago.

Is there a way to have OSX sort files in order of the date it was placed in a folder? Neither "Date Modified" nor "Date Created" works 100% as I thought it would. Or is the OSX definition of Date Modified/Created slightly different than Windows?

View 8 Replies View Related

OS X :: Weird Date Settings / Showing Wrong Modification Date?

Feb 7, 2007

I've noticed recently that when in Finder, all folders/files have a Modified Date of somewhere in January 2009 or January 2008, regardless of when it was actually modified/created. My clock at the top left-hand corner says Oct 20 though. Any thoughts?

View 24 Replies View Related

OS X :: Format External Hard Drive In Apple Partition Map Format?

Nov 5, 2009

I'm running Snow Leopard on my new Macbook Pro. I've got a 1.5TB External hard drive that I'm trying to figure out how to format in HFS+ with Apple Partition Map. I can figure out how to format in HFS using Disk Utility, however it still does it in GUID format and I do not know how to do it in Apple Partition Map.

Googleing this for hours has lead with all kinds of information on how to go to GUID FROM Apple Partition Map but not the other way around. I know GUID is the new hottness.. but this drive will be used exclusively to connect to my XBOX 360 and it supposedly only reads HFS+ when its formatted with Apple Partition Map. (I have tried it with Mac OS Extended (Journaled) with GUID, and the XBOX does NOT recognize it) I do not want to use Fat 32, (I know that that is the other major option) beacuse it limits file size.

View 1 Replies View Related

MacBook Pro :: Anyone Format External Drives In ExFAT Format?

Jan 9, 2011

I'm using Macbook Pro(2010, 10.6.6) and a PC with Windows 7. I need to transfer image files from both laptops to an external drive. I formatted the external drive in exFAT and wanted to know if there are any problems that might occur in the future. I already know there is an issue with such programs as Carbon Copy Cloner. I primarily need the drive for backup of the images and not system backups. Do you have any file corruption or other problems formatting in exFAT?

View 6 Replies View Related

Applications :: How To Convert TPS File Format To Other Video Format

Aug 4, 2010

i want to convert TPS file format to other video format in mac

View 2 Replies View Related

OS X :: Unable To Set Time And Date / Time Date Settings Wrong

Sep 30, 2008

So I shut down my computer earlier today for the first time in weeks. I restarted it and then left for a few hours for dinner.

I come home and I look at the last time MobileMe Sync and Time Machine did their things. They say they did them at 7:45. I look at the clock on my cable box and on my iPhone, both say 6:45.

Weird that the MacBook's time is wrong. I go into Time Date settings. I see that when the MacBook does the "Auto locate where you are so that we can set the appropriate time zone, etc. the MacBook things I'm in Rexford, Idaho.

I haven't been to Idaho in about 25 years, and my MacBook has been sitting in Southern Kalifornia for the last one year since I bought it.I've tried to have the MacBook auto-locate again, and it keeps finding me us in Rexford, idaho.

View 4 Replies View Related

ADVERTISEMENT