Prev: Help me find a circular reference cells located in unknown multita
Next: Count number of cells with "CAC"
From: fgg on 29 Apr 2010 19:58
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
From: Fred Smith on 29 Apr 2010 20:05
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" <fabioguimaraesgoncalves(a)gmail.com> wrote in message
news:a03b6981-f378-449a-a19d-56e7bfd6ec9a(a)t34g2000prd.googlegroups.com...
> 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

From: ozgrid.com on 29 Apr 2010 20:53
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" <fabioguimaraesgoncalves(a)gmail.com> wrote in message
news:a03b6981-f378-449a-a19d-56e7bfd6ec9a(a)t34g2000prd.googlegroups.com...
> 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

From: fgg on 29 Apr 2010 22:39
> 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.
From: Fred Smith on 30 Apr 2010 10:18
Format won't solve your problems. Convert it to text in a different column,
and export that.

Regards,
Fred

"fgg" <fabioguimaraesgoncalves(a)gmail.com> wrote in message
news:cd02f383-caaa-4daf-ab6b-8d81124c77de(a)u20g2000pru.googlegroups.com...
>> 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.

 | 
Pages: 1
Prev: Help me find a circular reference cells located in unknown multita
Next: Count number of cells with "CAC"