Posted to microsoft.public.excel.programming

bd420

external usenet poster

Posts: 1

Input mask for changing a numeric to a Zero

I have SSN information (Nine digits) that I would like to be able to
mask the first 5 digits to Zeros. Simply put, I need this SSN
(123456789) to be masked to (000006789). That's all I need, and I
apologize for not finding my answer within this group as I'm really
pressed for time.

Thank You,

bd.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Input Mask	Steven	Excel Worksheet Functions	1	January 16th 06 11:27 PM
input mask in excel	Osama Mira	Excel Worksheet Functions	6	December 6th 05 10:00 PM
Input Mask	Jimmy Clay	New Users to Excel	3	December 1st 04 01:16 AM
Input Mask	Mark Harrison	Excel Programming	3	December 3rd 03 01:45 PM
Mask input in input boxes?	Eric[_14_]	Excel Programming	4	November 29th 03 11:10 AM

All times are GMT +1. The time now is 01:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us