space

  • Thread starter Thread starter Loi
  • Start date Start date
L

Loi

Hi,
I have a column stored date data.

Ex: January-04.
I like to take out -. It will be "January 04".

Please show me how to do.

Thank you very much
Loi
 
one way would be to Format Cells - Custom - in the 'Type' section ente
'mmmm yy' without the apostrophes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate days in a given month between two dates 6
autofill date times 4
Averaging Month & weekdays 4
Change Date Values 1
sum total base on 2 criterias 4
space 4
search value based on 2 criteria 6
Converting numbers 5

Back
Top