Thread: Calculate (Auto Fill) cells with numbers and text.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bobby Atkinson Bobby Atkinson is offline
external usenet poster
  
Posts: 3
Default Calculate (Auto Fill) cells with numbers and text.
I will try it, I hope I know how to do a Custom format. I will let you know
soon, thanks

"Mike H" wrote:

Hi,

Apply a Custom format to the range of

"28XL"0000000

1 in A1
2 in A2
select both cells and drag down as required

Enter

"Bobby Atkinson" wrote:

I have a worksheet that I want to use text and numbers in the same cell, and
have
the column auto fill down when I enter the first number & text in the first
cell.
example.
cell A1 I would enter 28XL0001
Cell A2 should auto fill in 28XL0002
Cell A3 should auto fill in 28XL0003.

How can I get excel to do this?

Reply With QuoteReply With Quote