MS Excel / VBA help thread

Even if you change the format, if the number is :
40428.375
and not
40428
you'll still have the time, it just won't be displayed.

To remove that, I've found it useful to copy and paste into notepad, then paste back in. Change the format. And Ta DA. the .375 has gone.

Notebook. Making plain text.

Jesus Damo this is like watching my Gran trying to program a VCR.

There's really no point in manually removing the time value when you can just hide it, right? Why do you want to remove it?

If you can't get cell formatting to work, then try this:

1. Put your timestamp in cell A1
   
2. In cell B1 put
   [code]
   =TEXT(A1,"mmm-yy")
   [/code]
   
3. In cell C1 put
   [code]
   =TEXT(A1,"dd/mm/yy")
   [/code]
   
4. in cell D1 put
   [code]
   =TEXT(A1,"hh:mm:ss")
   [/code]
   
   

See what's happening there? You're basically forcing the formatting.