Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2007

Mon 28 Dec 2009, 14:42 Delegate Koviljka said...

Koviljka has attended:
Word Intermediate course
Excel Introduction course

Excel

On the bottom of page 19 on my Excel 2007 introduction workbook it said:
Use Ctr+"pipe" key to display formulas and show the absolute reference in the formula in column L.
It doesn't seem to work for me.
Can you please advise.
Many thanks
Kovi

Tue 29 Dec 2009, 12:19 Trainer Stephen said...

RE: Excel

Hi Kovi

Thanks for your question

Shortcut keys can sometimes vary depending on the layout of your keyboard, and regional settings

As an alternative I have found a reference that suggests that ctrl + ' will toggel between formulas and values

I enclose the link below

http://www.asaputilities.nl/excel-tips-shortcuts.php

Regards

Stephen

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Convert Text into Number