Thread: [Solved] Adding station numbers
View Single Post
 
Old 01-27-2015, 09:05 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Let's start over. I assumed your sheet would look something like this:

A1: 1+50.23
B1: 2+36.46
C1: [the formula doing the addition]

At any rate, conversion back might work with:
=INT(A1/100)&"+"&MOD(A1,100)

It won't work if the number after the plus sign ever exceeds 100.
Reply With Quote