Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
from "date" to "text"
Hi there,
I have cells formatted as date (e.g. 11/9/03) and I'd like to change the format to text. But when I do it, the values change as well (e.g. "36472"). What can I do to avoid this? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
from "date" to "text"
You can't. Dates, to Excel, are the number of days since Jan 1, 1900. That's
the what you are seeing when you try to change the format to text. You need to tell us why you want it as text. You have lots of other choices of formats available. If you absolutely have to have text, you will need to create a helper cell, and use a formula like: =text(a1,"m/d/yy") Regards, Fred "fgg" wrote in message ... Hi there, I have cells formatted as date (e.g. 11/9/03) and I'd like to change the format to text. But when I do it, the values change as well (e.g. "36472"). What can I do to avoid this? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
from "date" to "text"
Add a ' in front of the date. However, it's never a good idea to convert
dates/numbers to text. -- Regards Dave Hawley www.ozgrid.com "fgg" wrote in message ... Hi there, I have cells formatted as date (e.g. 11/9/03) and I'd like to change the format to text. But when I do it, the values change as well (e.g. "36472"). What can I do to avoid this? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
from "date" to "text"
You need to tell us why you want it as text. You have lots of other choices
of formats available. If you absolutely have to have text, you will need to create a helper cell, and use a formula like: =text(a1,"m/d/yy") Thanks for the suggestions. I'm saving this excel file as *.csv and opening it in a GIS. But the GIS is having problems reading the columns with dates and times (e.g. 30:26.4). I thought that a format change could help, but maybe not. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
from "date" to "text"
Format won't solve your problems. Convert it to text in a different column,
and export that. Regards, Fred "fgg" wrote in message ... You need to tell us why you want it as text. You have lots of other choices of formats available. If you absolutely have to have text, you will need to create a helper cell, and use a formula like: =text(a1,"m/d/yy") Thanks for the suggestions. I'm saving this excel file as *.csv and opening it in a GIS. But the GIS is having problems reading the columns with dates and times (e.g. 30:26.4). I thought that a format change could help, but maybe not. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |