[mso] Re: Excel 2000 replacement question
- From: "Steve Moghaddam" <m.steve@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sun, 1 Apr 2007 19:40:25 -0700
You can use Replace formula, or instance if you want "??" to be replaced in
YYYY-??-dd, you can use the formula ==REPLACE(A1,6,2,"00"), this will
replaces the two ?? character with 00.
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Robert Carneal
Sent: Saturday, March 31, 2007 10:14 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Excel 2000 replacement question
First, everyone, thanks for pointing out the formula of
=IF(AND(A1<>0,B1<>0,C1<>0),DATE(A1,B1,C1),"Check date") is indeed working
for you. I ended up reinstalling Excel and it is working as I believed it
should be. Though what was changed or corrected I have yet to discover.
I have a spreadsheet of roughly 4,100 dates. They are all of format
YYYY-MM-DD (text), and most have a bona fide "real" date in them. Most are
of the form 1892-10-22 now.
Some, due to deterioration of the cemetery stone have question marks where
the transcriber was unable to read the stone. In this case, s/he entered a
in one of the following formats:
YYYY-??-??
YYYY-??-DD
YYYY-MM-??
It would help me to change the question marks to zeroes. When I try using
Excel's Search and Replace (under the Edit pull down menu), using "?" for
Search for and "0" for Replace with (without quotes), it changes all the
dates to a single question mark. I do not want this. Example:
A text date in cell A1 of 1892-10-?? Becomes just a single question mark
upon doing a Search and Replace. Can I change that to read:
1892-10-00 (in text)?
Thank you.
Robert
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top. This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
