• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

Custom Cell Formatting

Hello Experts,

Here's my problem...

User enters "18" into cell. I want to cell to format into inches.  If you look at cell A2, that's exactly how I want it to be appear.

Just to be clear, cell A2 is ONLY showing you want I want it to look like.

Formatting Inches
Thank you in advance for your help!

~ Geekamo
1 Solution
you can do this in formating the Col A
Select the entire column A right click Format Cell
Choose Custom and paste the below
Note at the end is 2 single quotes ' ' (no space in between)

This way you have the formating and still the figure is a number not text. If you do not want space between the last digit and the double single quotes then remove the underscore _ to be like this

Check the attached file.

General" ''"
(Between the double-quotes is a space followed by two single quotes.)

Edit: The double quotes aren't required, so the following is sufficient...
General ''
(A space followed by two single-quotes.)

GeekamoAuthor Commented:
This is great!  Thank you!

~ Geekamo
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now