|
AHiltz
|
12-22-2006, 12:30 PM
Post subject: Excel question
|
#1 (permalink)
|
|
4-of-a-Kind
Join Date: Mar 2005
Location: Coldbrook, NS
Posts: 1,589
|
|
My boss has a spreadsheet that has data such as 10.28.2006 that is supposed to be a date, but Excel doesn't recognize it as such. Is there an easy way to convert these values over to a recognized format?
|
|
|
Play for FREE and practice your game at...
Join the FTR Poker Forum to disable these banners and start posting!
|
|
drmcboy
|
|
DrButtInski
Administrator
Join Date: Aug 2004
Posts: 9,602
|
|
highlight the cells that have the dates, do a search and replace (Control-H) - replace the dot (.) with a slash (/).
|
|
|
|
koolmoe
|
|
Full House
Join Date: Jun 2004
Location: Drowning in prosperity
Posts: 1,279
|
|
<edit> what he said </edit>
|
|
Poker is freedom
|
|
|
|
12-22-2006, 04:41 PM
Post subject: Re: Excel question
|
#4 (permalink)
|
|
|
|
Quote:
|
Originally Posted by AHiltz
My boss has a spreadsheet that has data such as 10.28.2006 that is supposed to be a date, but Excel doesn't recognize it as such. Is there an easy way to convert these values over to a recognized format?
|
Highlight said cells. Right click on any highlighted cell. Click 'Format Cells'. 'Number' tab. Click 'Date'. Select the format you want the date to be displayed in. Click 'OK'.
|
|
|
|
LeFou
|
|
4-of-a-Kind
Join Date: Jul 2004
Location: Dallas, TX
Posts: 2,361
|
|
sed -i 's/([\d]{1,2}).([\d]{1,2}).([\d]{4,4})/\1\/\2\/\3/g'
should be fine
|
|
|
|
AHiltz
|
|
12-22-2006, 07:05 PM
Post subject: Re: Excel question
|
#6 (permalink)
|
|
4-of-a-Kind
Join Date: Mar 2005
Location: Coldbrook, NS
Posts: 1,589
|
|
Quote:
|
Originally Posted by dwarfman
Quote:
|
Originally Posted by AHiltz
My boss has a spreadsheet that has data such as 10.28.2006 that is supposed to be a date, but Excel doesn't recognize it as such. Is there an easy way to convert these values over to a recognized format?
|
Highlight said cells. Right click on any highlighted cell. Click 'Format Cells'. 'Number' tab. Click 'Date'. Select the format you want the date to be displayed in. Click 'OK'. |
That doesn't work
|
|
|
|
AHiltz
|
|
4-of-a-Kind
Join Date: Mar 2005
Location: Coldbrook, NS
Posts: 1,589
|
|
Quote:
|
Originally Posted by drmcboy
highlight the cells that have the dates, do a search and replace (Control-H) - replace the dot (.) with a slash (/).
|
I'll try that
|
|
|
|
Staresy
|
|
12-22-2006, 11:10 PM
Post subject: Re: Excel question
|
#8 (permalink)
|
|
Full House
Join Date: Sep 2004
Location: Following the Herd to 6-Max Land
Posts: 1,240
|
|
Quote:
|
Originally Posted by dwarfman
Quote:
|
Originally Posted by AHiltz
My boss has a spreadsheet that has data such as 10.28.2006 that is supposed to be a date, but Excel doesn't recognize it as such. Is there an easy way to convert these values over to a recognized format?
|
Highlight said cells. Right click on any highlighted cell. Click 'Format Cells'. 'Number' tab. Click 'Date'. Select the format you want the date to be displayed in. Click 'OK'. |
I think this is right, although you would have to make sure that the format was mm/dd/yyyy, as I think the default would be dd/mm/yyyy
|
|
|
|
drmcboy
|
|
DrButtInski
Administrator
Join Date: Aug 2004
Posts: 9,602
|
|
no, excel doesn't recognize them as dates with the dot in there. You can format 10.26.2008 as a date, but it's still 10.26.2008.
|
|
|
|
salsa4ever
|
|
Full House
Join Date: Jun 2005
Location: Melbourne
Posts: 1,073
|
|
you can actually change a series of properly formatted data so that it reads 20.10.2006 or 10.20.2006 by going to the "custom" section of the format cells
but I don't think you can do it the other way around
|
Quote:
|
Originally Posted by bigred
Would you bone your cousins? Salsa would.
|
Quote:
|
Originally Posted by salsa4ever
well courtie, since we're both clear, would you accept an invitation for some unprotected sex?
|
|
English
Deutsch
Español
Français
Italiano
Nederlands
Pусский
Svenska
05-26-2012, 03:08 PM Australia Legalized Online Poker coming up in next 6 to 12 Months
Linear Mode
