Shortcut to convert dates into numbers and vice versa
Many a times, you would have entered a number in a cell next to a date, excel assumes you are entering another date and converts this number to a date. Here's the shortcut to quickly change the format instead of going through the format cells menu
Press Ctrl+shift+~ this will change the date back to a number
On the other hand if you have entered dates in a cell next to a number and excel converts this into a number just press Ctrl+shift+# to get back the date
Create a bar chart in your cell
Ever wondered how to create a bar chart in you cell without invoking the chart menu. This little trick uses the REPT (repeat) function and the 'pipe' or 'vertical bar' character "|". The REPT function simply repeats a specified character a specified number of times. =REPT(text,times_to_repeat). This effect works best when the cells containing the bar charts use Arial font.
For example, =REPT("|",20) would result in ||||||||||||||||||||
By using a cell reference (B2) for the times to repeat, you can easily create bar charts for the data in your cells.
IAs you might expect, this trick will not work well for large numbers. However, for larger numbers, you could reduce the 'times_to_repeat' value by dividing it by some factor (i.e. 100 or 1000).
Now you can invite other members to be a part of this member community, please forward the link www.catroops.blogspot.com to your friends/members to enable them to register on our feeds
No comments:
Post a Comment