| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a prefix containing text and zero?
Thanks! Got it working now!
"rsenn" wrote: Try using a custom number format. In Excel 2002 you would get to this by way of Format Cells Number Custom In the Type box (it likely says General as a default), type "SN00"0;;; This will cause "SN00" to precede the number that you type type in. For example, 12 will display as SN0012. Negative numbers, zero, and text entries will display as blank. -- rsenn ------------------------------------------------------------------------ rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050 View this thread: http://www.excelforum.com/showthread...hreadid=487549 |
Threaded Mode
