Maybe with a formula:
=TEXT(INT(A1), "00000") & IF(MOD(A1, 1), TEXT(10000 * MOD(A1, 1), "-0000"), "")
Maybe with a formula:
=TEXT(INT(A1), "00000") & IF(MOD(A1, 1), TEXT(10000 * MOD(A1, 1), "-0000"), "")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks