three-letter week

[wz]

How to format a column as three-letter week, eg. Tuesday->TUE

thanks

 

[Guest]

hi,
If you have a date(11/5/04) in a2, in b2 you can enter
=text(a2,"ddd") results = Fri

 

[wz]

Hi,
Thanks for your reply, but it's not right in my case.
I have a text Friday in a2, and I want to show it as Fri.
even I insert a column b, and use =text(a2,"ddd") in b2, it still gives me
Friday in b2.

 

[JulieD]

Hi

right mouse click on the column, choose format cells, on the numbers tab
choose custom and in the white line type
ddd

Cheers
JulieD

 

[Don Guillett]

All assumed you had DATES. For Tuesday
=left(a2,3)

 

[wz]

I did it before my post, no change happens. Friday is still Friday

thanks

 

[wz]

No, all I have are text (eg. "Friday"), not dates.
And I'd prefer not to add an extra column to the sheet. But if I have no
other choice, it's ok.

thanks

 

[JulieD]

Hi wz

sorry, assumed you had dates not text ... you can't change it in the same
cell unless you use some code - you need to use a helper cell e.g. if you
have Friday in cell A1 then in cell A2 (or B1) type
=LEFT(A1,3)
and then you can copy this
and edit / paste special - values
over the original data and then delete these formulas.

Hope this helps
Cheers
JulieD

 

[wz]

It works now. Thank you to you all.

 

[Don Guillett]

If you want to change use a macro

for each c in selection
c.value=left(c,3)
next

 

[RagDyer]

Text To Columns should give you what you need, without using additional
columns.

Click on "Fixed Width", then <Next>,
Set the "Break Line" at 3 characters, then <Next>,
Click on the right hand column in the preview window and then click "Do Not
Import Column", then <Finish>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I did it before my post, no change happens. Friday is still Friday

thanks

 

[JulieD]

Hi RD

good suggestion

Cheers
JulieD

Text To Columns should give you what you need, without using additional
columns.

Click on "Fixed Width", then <Next>,
Set the "Break Line" at 3 characters, then <Next>,
Click on the right hand column in the preview window and then click "Do
Not
Import Column", then <Finish>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I did it before my post, no change happens. Friday is still Friday

thanks