PDA

View Full Version : Solved: Attaching a number to another in a single cell.



pico
11-23-2006, 02:55 PM
I'd like to attach a number to another number in a single cell. Example
Cell A1=146601-Num

Where Num=T+10

Where T is the variable that changes. T can be any value from 0 to 99.

ps. 146601-(dash) Num

mdmackillop
11-23-2006, 03:08 PM
="146601-"&D1+10 assumuning T is in D1, or are you looking for a VBA solution

pico
11-23-2006, 03:18 PM
Thank you. Works perfectly.