Posted to microsoft.public.excel.misc
|
|
numeric value is not formatting correctly
Thank you guys.
It worked perfectly.
Bernard Liengme wrote:
That is because the LEFT function returns text: you may have 23.00 but it is
still text made up of digits.
To coerce a numeric value you need to 'do some math' on the result. So any
of these work:
=--LEFT(A2,5) 'preferred
=LEFT(A2,5)*1
=LEFT(A2,5)+0
best wishes
Hello everybody,
I have one small problem. Hope someone can shed some light on.
[quoted text clipped - 12 lines]
Any help will be greatly appreciated.
Fam
--
Message posted via http://www.officekb.com
|