Excel cell format to 2006-07-18 14:30:20.120 How ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to write a cell format that includes 1/100 of a sec. in Excel.

the only optiona available are yy-mm-dd hh:mm:ss how do I get a better
resolution?
 
To produce the format that's in your subject line, you would use:

yyyy-mm-dd hh:mm:ss.000
 
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

How to customize =Now() 11
date format 1
Preserving date format 1
Date format - India/USA 7
Custom Number Formats for Excel 2007 1
dd/mm/yy if i change to some other format 2
cell format - not automatically taking effect 4
How do I delete merged cells in Excel without deleting the final d 5

Back
Top