Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you enter a ratio e.g. 100:1 into a cell? | Excel Worksheet Functions | |||
Event 1001 & 1004 | Excel Discussion (Misc queries) |