LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ben ben is offline
external usenet poster
 
Posts: 22
Default number format for a cell

Hello,

I want to store a 12 digit number in a some cells. Ideally, I'd like it with
a space after every 4th number and such that when I copy and paste to other
applications there is no space in between. I tried doing a custom format
set to "#### #### #### ####" but had some serious problems with that.
Firstly, the last number for some reason would change itself to '0' and
another problem I had was that pasting the number would maintain the spaces
even though it was only there in the formating and not in the way the number
was stored.

Can anyone give me some guidance on this.
Thanks you very much.
 
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
Format cell to Number David R. S. Excel Discussion (Misc queries) 14 August 17th 09 04:03 PM
Number format in cell changes Rubie Excel Discussion (Misc queries) 8 August 26th 08 08:30 PM
Cell Number format Lamb Chop Excel Discussion (Misc queries) 3 July 25th 06 11:29 PM
Format a cell with a custom number format Armor Excel Worksheet Functions 4 January 29th 06 11:25 PM
CELL/NUMBER FORMAT BIBBYBIBBER Excel Discussion (Misc queries) 5 November 18th 05 09:02 PM


All times are GMT +1. The time now is 04:13 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"