Changing the date format in a cell

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

Guest

I have generated an Excel file from one of our applications, and it has a
field for a date with a format of 9-2006. I need to put a leading zero in
front of the month so it sorts correctly. Is there an easy way to do this?
I tried to set a custom format to it. It doesnt seem to take until I click
off of it and back on it, then it updates it and works. i have to do it to
8,000 rows and it would take forever.

TIA

Scott T.
 
Is your sheet set to "Manual Calculation"? Click Tools>Options |
Calculations and make sure "Automatic" is checked. Set your format
and all should update at the same time.

HTH

Bruce
 
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

Conditional formatting dates 3
Which is the best MBOX Converter Tool different formats conversion? 5
Cell format 3
Excel cell Formatting 1
HDMI is a terrible format and I wish it never existed 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
help with format change of date part of concatenate formula 1
Excel How to change the "Short Date" format in Excel? 4

Back
Top