New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Switcher Hangout The place for switchers to discuss their new machines, and how to work with OS X. General support can be had here for newbie stuff, like "How do I restart my new iMac?" :)

Find feature in Excel not working


Post Reply New Thread Subscribe

 
Thread Tools
staygood

 
Member Since: Nov 08, 2013
Posts: 3
staygood is on a distinguished road

staygood is offline
can not locate an item (7/1/12) in an Excel worksheet in order to replace it with another date. (Office for Mac 2011)
QUOTE Thanks
Joncon

 
Joncon's Avatar
 
Member Since: Nov 05, 2013
Posts: 24
Joncon is on a distinguished road

Joncon is offline
Are you using command-f to open the find feature?

Try searching for 07/01/2012.

I have the same office version that you have and that is the way it formats dates.

MacBook Pro 13" 2.5GHz i5 / iPhone 5 16GB
QUOTE Thanks
staygood

 
Member Since: Nov 08, 2013
Posts: 3
staygood is on a distinguished road

staygood is offline
Thanks for your response. I opened the Find feature with the Edit drop down menu. Am trying to update an old Excel worksheet that has dates entered as 7/1/12, and change them all to 1/1/2014. Tried entering 07/01/2012 in the find menu but it could not be located. Any other suggestions?
QUOTE Thanks
Checco

 
Member Since: Nov 09, 2011
Posts: 225
Checco has a spectacular aura about
Mac Specs: 21.5" iMac Mid-2011 ~ 15" MBP Mid-2012 ~ iPad 4 16GB ~ iPhone 5 16GB

Checco is offline
Click on one of the 7/1/12 cells and look at the formula edit (name?). Use what you see in there as your search text.

I formatted my cells to have 'm/d/yy' to match American date format, see Cell A1 in my attachment. However, the "formula edit" shows '2012/07/01'.

Searching for 2012/07/01 results in a hit. In your case, the "formula edit" will likely show a different format, but use whatever you see there in your search.
Attached Images
File Type: jpg Excel.jpg (12.5 KB, 11 views)
QUOTE Thanks
staygood

 
Member Since: Nov 08, 2013
Posts: 3
staygood is on a distinguished road

staygood is offline
Checco: Many thanks! That solved my problem. Your responses are very much appreciated.
QUOTE Thanks
Checco

 
Member Since: Nov 09, 2011
Posts: 225
Checco has a spectacular aura about
Mac Specs: 21.5" iMac Mid-2011 ~ 15" MBP Mid-2012 ~ iPad 4 16GB ~ iPhone 5 16GB

Checco is offline
Glad to help!
QUOTE Thanks

Post Reply New Thread Subscribe


« New hard drive and use | Menu Bar Backup Icon »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Question about Excel 2004 for Mac schwine1 OS X - Apps and Games 0 11-08-2012 11:23 AM
problem with terminal walkntalk OS X - Operating System 6 08-16-2011 03:36 PM
how to copy a row of excel to firefox chidambaram OS X - Apps and Games 0 06-04-2009 04:26 AM
help me convert something, please. krrose27 Switcher Hangout 4 05-25-2007 03:10 AM
find, in finder not working k2snowboards88 OS X - Operating System 0 05-17-2007 06:02 PM

All times are GMT -4. The time now is 01:46 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?