Thread: Input mask for changing a numeric to a Zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_441_] Leith Ross[_441_] is offline
external usenet poster
  
Posts: 1
Default Input mask for changing a numeric to a Zero

Hello Bd420,

A1 = 123456789
A2 = "00000" & RIGHT(A1, 4)

Result in A2: 000006789

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=496852

Reply With QuoteReply With Quote