Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with special cell formatting
When I specify 'Social Security Number' as the format and enter 123456789,
the display is 001-23-4567. The same addition of 2 leading zeroes happens for phone number and zip code as well. Is there a default setting that I may have inadvertently changed? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with special cell formatting
Bill,
Use Tools / Options.... Edit tab, uncheck "Fixed decimal entry" HTH, Bernie MS Excel MVP "BillRupp" wrote in message ... When I specify 'Social Security Number' as the format and enter 123456789, the display is 001-23-4567. The same addition of 2 leading zeroes happens for phone number and zip code as well. Is there a default setting that I may have inadvertently changed? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with special cell formatting
Thanks Bernie, I'll try it tonight, the spreadsheet is at home.
Bill "Bernie Deitrick" wrote: Bill, Use Tools / Options.... Edit tab, uncheck "Fixed decimal entry" HTH, Bernie MS Excel MVP "BillRupp" wrote in message ... When I specify 'Social Security Number' as the format and enter 123456789, the display is 001-23-4567. The same addition of 2 leading zeroes happens for phone number and zip code as well. Is there a default setting that I may have inadvertently changed? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Formatting Problem | Excel Discussion (Misc queries) | |||
problem with cell formatting | Excel Discussion (Misc queries) | |||
Cell formatting problem | Excel Discussion (Misc queries) | |||
Copy Paste Special Link Cell Problem | Links and Linking in Excel | |||
Special cell formatting | Excel Discussion (Misc queries) |