How can I get cell A1 to show trailing zeros?
I've entered =CONCATENATE(A1," inches")
When A1 equals 1.50 or .060 it displays 1.5 inches or .06 inches
I need those missing zeros!
THANKS
How can I get cell A1 to show trailing zeros?
I've entered =CONCATENATE(A1," inches")
When A1 equals 1.50 or .060 it displays 1.5 inches or .06 inches
I need those missing zeros!
THANKS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks