Removing the format of the action created

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

estyMonsty

Thread Starter
Joined
Mar 22, 2017
Messages
20
Hi All,

Not sure what setting I've turned on but now when I hyperlink or insert a date it shows the word instead of the outcome (does that make sense?).
When I print it is correct but when I look on the screen it shows the format e.g. displays "d MMMM yyyy" instead of "19 July 2018".

Thanks,
E
 

Attachments

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,612
There is a setting that can either show the formula or the result, there is a keyboard shortcut but I don't remember it right now google 'switch between formula and value' maybe you'll find it
 

estyMonsty

Thread Starter
Joined
Mar 22, 2017
Messages
20
Thanks for pointing me in the right direction! Found the answer Shift + F9 (singular) OR Alt + F9 (entire).
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top