If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Format Number
I have numbers that import into Excel and they come in
with the General format. Example: 34350 The number is actually the amount of a check for $343.50 I need to be able to format the cells to show this format. I have been trying to create a custom currency format and have had no luck. Can anyone help? |
#2
|
|||
|
|||
Format Number
Just format an empty, unused cell to the currency format that you wish to
use. Enter 100 into this cell. Right click in this cell and choose "Copy". Now, select the imported data. Right click in this selection and choose "PasteSpecial". Click on "Divide", then OK. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Becky" wrote in message ... I have numbers that import into Excel and they come in with the General format. Example: 34350 The number is actually the amount of a check for $343.50 I need to be able to format the cells to show this format. I have been trying to create a custom currency format and have had no luck. Can anyone help? |
#3
|
|||
|
|||
Format Number
That worked. Thanks!!
-----Original Message----- Just format an empty, unused cell to the currency format that you wish to use. Enter 100 into this cell. Right click in this cell and choose "Copy". Now, select the imported data. Right click in this selection and choose "PasteSpecial". Click on "Divide", then OK. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Becky" wrote in message ... I have numbers that import into Excel and they come in with the General format. Example: 34350 The number is actually the amount of a check for $343.50 I need to be able to format the cells to show this format. I have been trying to create a custom currency format and have had no luck. Can anyone help? . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
page number format in landscape setup | sulalicia | Page Layout | 1 | June 21st, 2004 10:34 PM |
Number Format | Wendy | Tables | 1 | June 8th, 2004 06:50 AM |
Page Number Format | Rob Pet | Setting Up & Running Reports | 1 | May 31st, 2004 06:27 AM |
autotext entry containing table comes in with text in number format | Newt | Tables | 4 | May 20th, 2004 04:31 PM |
Changing default number format in worksheets | John deChadenedes | Worksheet Functions | 0 | October 9th, 2003 05:52 PM |