Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba-excel-training - Excel

vba-excel-training - Excel

ResolvedVersion Standard

Wed 30 Jan 2008, 16:22 Delegate Joanna said...

Joanna has attended:
Excel Intermediate course

Excel

hi Katie
how do you convert numeric data without the date auto format

thanks

Joanna

Wed 30 Jan 2008, 16:50 Trainer Katie said...

RE: Excel Format

Hi Joanna,

Hope you enjoyed the training today.

Sometimes if you type in numbers with symbols like / or : Excel automatically formats them into Date or Time.

To keep these numeric data as you type, simply click on FORMAT menu -> CELLS -> NUMBER tab -> General or Text

Regards,

katie

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips

vba-excel-training - Excel

Excel

RE: Excel Format

Excel articles

Excel tip:

Fill formulae across a sheet