Help required

Peter1973

Well-known Member
Joined
May 13, 2006
Messages
933
I have a spreadsheet which I enter three different values in they are :

7-5
8-6
9-5

This is not 7 minus 5 but it is actually how I want it displayed as I repeat these three values frequently is there any way I can assign a quick button to them so I could enter them more quickly. I cant copy and paste as they change from cell to cell.

Any help appreciated.
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
Either format the cells as text first or use the text qualifier ' to enter '7-5
 

Watch MrExcel Video

Forum statistics

Threads
1,111,699
Messages
5,541,271
Members
410,543
Latest member
ExcelGlenn
Top