Prev Previous Post   Next Post Next
  #7   Report Post  
Mark
 
Posts: n/a
Default

Hi,
why don't you use four separate cells for each of the four
digit numbers.

- Mark
-----Original Message-----
I have created a custom format for a cell that will be

used in a general
company form. The custom format is for a credit card

number and was written
as follows: #### #### #### ####. When ever I type in

a number 9999 9999
9999 9999 the final digit is convert to a zero. I do

not understand why it
is doing this. It is not being rounded. Can anyone help

correct this very
irritating formatting issue?

Thanks
--
bb
.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel 2002 custom toolbars fick Excel Discussion (Misc queries) 4 December 13th 04 09:51 PM
Excel2000: Custom data validation and named ranges Arvi Laanemets Excel Discussion (Misc queries) 9 December 10th 04 07:05 PM
Date on two lines using a custom cell format possible? .:mmac:. Excel Discussion (Misc queries) 5 December 4th 04 09:41 PM
Custom Header Josh O. Excel Discussion (Misc queries) 1 December 1st 04 06:56 PM
Shortcut for Filter- Custom Autofilter Eileen Excel Discussion (Misc queries) 2 November 27th 04 01:09 PM


All times are GMT +1. The time now is 06:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"