I am trying to have a specific format for a cell that i need some help with:
the value of A3 = A1&" / "&A2 --> to give 3 / 3 for example - thats fine
but the formatting of A1 and A2 are such that when 3 is entered it displays 3.0kg (due to 0.0"kg" as format)
so now, how do i get the format of A3 to show 3.0kg / 3.0kg??
This is one way
= A1&"kg / "&A2&"kg"
Please Read Forum Rules
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post
Top Excel links
for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
that does work to some extent - thanks!
but... i loose the '0's behind the decimal due to not having specific cell formatting.
unless anyone else can come up with another solution...
Try this and report back:
legend! worked a treat. thanks.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By NickyJ in forum Excel General
Last Post: 07-23-2008, 06:59 AM
By mivital in forum Excel Formulas & Functions
Last Post: 07-16-2008, 01:52 PM
By brianzs in forum Excel Programming / VBA / Macros
Last Post: 01-15-2008, 12:13 PM
By tryer in forum Excel General
Last Post: 06-16-2007, 03:26 AM
By xlguy in forum Excel Formulas & Functions
Last Post: 05-05-2007, 05:36 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1