Hi all,
How can I copy the exact text of one cell into another? When I use a cell reference for example "=A1" and in A1 is let's say "300,000,000", the cell which contains the reference formula become 300000000. Similarly, when a the source cell is empty (""), the destination cell becomes zero. How can I tell Excel that I want the exact text copy?
cheers
torixoz
If a cell (A1) has a value in this format 3,000,000 then using =A1 will show 3,000,000 if A1 is blank then using =A1 will display 0. The first example will not change the format or value of a cell unless you have used the =Text( property or formatted the cell as a number removing the tick from the checkbox for using a "," as a seperator. To prevent 0 showing use =IF(A1="","",A1)
Not all forums are the same - seek and you shall find
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks