| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Seperate with space
Could someone help me place a space between the
number and the letter S Private Sub Increment_Click() With Me.Range("K20") ..Value = .Value + 1 ..NumberFormat = "00000""S""" thanks Pat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add two cells from seperate work sheets into a cell on seperate wo | Excel Worksheet Functions | |||
| How do I have seperate headers for seperate pages in 1 worksheet? | Excel Discussion (Misc queries) | |||
| How do I seperate a full name field out into three seperate columns? | Excel Worksheet Functions | |||
| How do I seperate data from a pivot into seperate worksheets? | Excel Discussion (Misc queries) | |||
| place text seperated by a space in a column into seperate columns | Excel Worksheet Functions | |||
Threaded Mode
