Thread
:
Data manipulation help required !
View Single Post
#
5
Ken Macksey
Posts: n/a
Hi
assuming the data is in cell c3, you could do something like
=MOD(C3,1)
And then do what you want with it like multiply it by 1000 etc
=(MOD(c3,1)) * 1000
HTH
Ken
Reply With Quote