How to put Time or Date Only in Cell 1) Time HHMMSS 2) Date YYYYMMDD

  • Thread starter Thread starter tmb
  • Start date Start date
T

tmb

I need to have a cell = the current time in the format HHMMSS

And when I export as Comma Delimited or Fixed Length Ascii, I need for it to
remain in that format.

Ditto for Date as YYYYMMDD

I've played around with both =TIME and =DATE but no luck.

Can anyone tell me how to do this?

AND, once the forumula is in the cell... how can I get it to update to the
current time or date?

thanks for any help
 
I formatted my times as hhmmss and my dates as yyyymmdd and then did a
file|saveAs.

I chose the comma separated values (*.csv) and I got what you wanted.

I opened it in notepad to verify--not excel.
 
Back
Top