[prjohnson]

I'm trying to use MS Excel & I'm looking for a shortcut to add the Inch symbol ( " ) to the end of a list of numbers.
I have thousands of numbers & most are different & don't have the time of going through each cell. Anyone have any idea on how to do this.
1.5
2.3
8.9

To

1.5"
2.3"
8.9"

Thanks!

[bono426]

try highlighting them, right clicking and then format cells

then for numbers, you might have to check out custom... not sure if they have an inch one standard

[prjohnson]

Originally Posted by bono426

try highlighting them, right clicking and then format cells

then for numbers, you might have to check out custom... not sure if they have an inch one standard

That's how I was trying to do it, but no luck...

[LandRover]

If you highlight/right click/format cells, then on the 'number' tab there is a 'custom' option at the bottom of the list...I couldn't get it to accept it when I entered #.##" as the format, but there may be a way to do it through there...

[Hoobly_Goob]

Originally Posted by LandRover

If you highlight/right click/format cells, then on the 'number' tab there is a 'custom' option at the bottom of the list...I couldn't get it to accept it when I entered #.##" as the format, but there may be a way to do it through there...

If you use two apostrophes instead of a " it will work.

[bono426]

got it

format cells, numbers, custom, then type in #0 [$ "]

hope that helps

[bono426]

or delete the space between the $ and the " to make it closer

[prjohnson]

Figured it out!!
Don't know if anyone else would ever want to know, but here it goes
A2 put in =CONCATENATE(A1,"""") then drag down.