Adding New Cell Formats

D

dpal

I have added a few custom Cell formats to the list given with Excel. #,##0 etc.
I have adde 0) and (0) etc.
Is there a formula I can write to enter feet and inches so I don't have to
use ' & " everytime I enter.
I have to type 1'-2". Is there a way I can format the cell so I just have to
enter 1-2 or something short like that?

thanks
dpal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Excel does not accept text format! 0
Cumulative formula for word table 0
Split cells next to 1 cell 1
Images are pixelated when saving to PDF 0
Text in Custom Number Formats 0
Merging from an Excel file with graphics 1
Word macro that can call cells out of Excel for a find and replace 0

Top