View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved
 
Posts: n/a
Default From 1001 to 1001-1

Hello from Steve Dee

Col A1 I have 1001 In Col B1 I would like to put a -1 so it looks like
1001-1 please.

Secondly col C1 I have 23 in Col DI wolud like to put in front off it 10 to
look like 1023 please.

Thankyou for yor time.