financial excel course london - date format

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » financial excel course london - Date Format

financial excel course london - Date Format

resolvedResolved · Low Priority · Version Standard

Claire has attended:
Excel Advanced course

Date Format

I downloaded data from SAP into Excel. I used Functions to extract the date from the main description text cells. However for some cells, i needed to add the date in manually. The dates were inputted in different formats. Even when using the Format Cells menu and then changing the date format to match that of the format that came out of SAP, it still didn't change the format. So that when i did a pivot table, the dates didn't match. How do I get them to hold the same format?

RE: Date Format

Hi Claire

Thanks for your question.

Have you tried using the Format Painter to copy formatting from the cells that are formatted correctly to the ones that aren't?

Amanda


 

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips


Server loaded in 0.09 secs.