troubleshooting Question

excel 2016 - custom format cell with text value

Avatar of Frank .S
Frank .SFlag for Australia asked on
Microsoft OfficeMicrosoft Excel
2 Comments1 Solution7 ViewsLast Modified:
hi experts i use the custom format cell many times but always with numeric values. This time i need it with a text value, so cell shows "L/H"and i want to format the cell to show 1x L/H, but the 2 options i can change the cell to are either L/H or R/H so i need format to just show 1x infront of any text value i enter in the cell.
How do i format the cells for this display?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros