HELP!! Trying to convert numbers.

[Techie]

Here is my problem.

i have a series of 3 digit numbers that
need to be cinverted to a series of 4 digit
numbers using this following

722 needs to read as 5622 and in the next collum SV-7822
in the collum's to the right.
what type of formula is this and how can i do it?
The above is an example, i have a whole range of 3 digit numbers
that need the exact. rules applied to all numbers.
which is why i need a formula to do it.

Help someone please!!!!

 

[Dan E]

I'm not completely clear on what your looking for but if 722 was in A1
in B1: = A1 + 4900
in B2: = ="SV-" & A1 + 7100

only works if #2 is always 4900 larger than #1 and #3 is always 7100 larger than #1

Also works
in B1: =ROUND(A1 * 7.78670360110803,0)
in B2: ="SV-" & ROUND(A1 * 10.8337950138504,0)

Not sure if thats what your looking for, but if not . . . you may want to provide a touch more detail

Dan E

 

[Dan E]

in B1 put

= A1 + 4900

in C1 put

= "SV-" & (A1 + 7100)

Dan E