StevenHook
asked on
I need help with date formatting in excel (mac)
Hi,
I have a spreadsheet with names and dates to be printed onto certificates.
The dates are formatted in excel to look like "9 July 2014" but when you double-click the cell it reads 9/7/14 in the formula bar. and in the print software it's picking up as "9/7/14"
Is there not a way to copy the formatted date text from that column and paste it as text instead of as a date?
Thanks
Steve
I have a spreadsheet with names and dates to be printed onto certificates.
The dates are formatted in excel to look like "9 July 2014" but when you double-click the cell it reads 9/7/14 in the formula bar. and in the print software it's picking up as "9/7/14"
Is there not a way to copy the formatted date text from that column and paste it as text instead of as a date?
Thanks
Steve
ASKER
Hi,
Yes, we have formatted it correctly like that. so it looks right on the sheet.
But when you copy it, or it copies 9/7/14 or when you format as text it gives some number other strange number (like maybe 5 or 6 digits)
Thanks
Steven
Yes, we have formatted it correctly like that. so it looks right on the sheet.
But when you copy it, or it copies 9/7/14 or when you format as text it gives some number other strange number (like maybe 5 or 6 digits)
Thanks
Steven
Since the cell you paste is formated to number
so you should do it not just copy cells bus paste cells also
Duncan
so you should do it not just copy cells bus paste cells also
Duncan
ASKER
I'm sorry, you're not understanding the problem.
The dates are formatted in excel to look like "9 July 2014" (which is what we want) but when you double-click the cell it reads 9/7/14 in the formula bar. and in the print software it's picking up as "9/7/14"
The dates are formatted in excel to look like "9 July 2014" (which is what we want) but when you double-click the cell it reads 9/7/14 in the formula bar. and in the print software it's picking up as "9/7/14"
Now I know it, it is normal, why you double-click the cell? for what ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That looks like it's working - thanks!
There is a lot of options for date such as "11 Jun 2014"
Take a look at Excel on Mac for format cell insruction
http://www.dummies.com/how-to/content/office-2011-for-mac-format-dates-and-times-in-exce.html
Duncan