• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 317
  • Last Modified:

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
0
StevenHook
Asked:
StevenHook
  • 4
  • 3
2 Solutions
 
duncanb7Commented:
You can select the cells you want, and mouse right-click->format cells

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
0
 
StevenHookAuthor Commented:
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
0
 
duncanb7Commented:
Since the cell you paste is formated to number
so you should do it not just copy cells bus paste cells also

Duncan
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
StevenHookAuthor Commented:
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"
0
 
duncanb7Commented:
Now I know it, it is normal, why you double-click the cell? for what ?
0
 
Rob HensonFinance AnalystCommented:
If you are not using the date for any calculations convert it to text using the following formula, assuming date in column B:

=TEXT(B2,"dd mmmm yy")

Then copy and paste values to overwrite if so required.

Thanks
Rob H
0
 
duncanb7Commented:
you can convert it to text from A1="9  Jan 2014" to B1 with this formula

=TEXT(B1,"dd mmmm yyyy"),

 Is it what you need?

Duncan
0
 
StevenHookAuthor Commented:
That looks like it's working - thanks!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now