Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Can I enter dollar amount without the $ appearing on the left side of
the cell? Thanks, Ralphael, the OLD one |
#2
![]() |
|||
|
|||
![]()
change the format
-- Don Guillett SalesAid Software "Ralphael1" wrote in message oups.com... Can I enter dollar amount without the $ appearing on the left side of the cell? Thanks, Ralphael, the OLD one |
#3
![]() |
|||
|
|||
![]()
Sure, just format the cells as Number or Currency rather than Accounting.
Gord Dibben Excel MVP On 6 Oct 2005 14:45:56 -0700, "Ralphael1" wrote: Can I enter dollar amount without the $ appearing on the left side of the cell? Thanks, Ralphael, the OLD one |
#4
![]() |
|||
|
|||
![]() Gord Dibben wrote: Sure, just format the cells as Number or Currency rather than Accounting. All well and good up to a point...but....5.00 appears as just 5. the zeros after the decimal are nowhere to be seen... Ralphael, the OLD one |
#5
![]() |
|||
|
|||
![]()
formatnumberlets you select the decimals. Look again
-- Don Guillett SalesAid Software "Ralphael1" wrote in message oups.com... Gord Dibben wrote: Sure, just format the cells as Number or Currency rather than Accounting. All well and good up to a point...but....5.00 appears as just 5. the zeros after the decimal are nowhere to be seen... Ralphael, the OLD one |
#6
![]() |
|||
|
|||
![]()
OK, Thanks, now I think I understand something that was palin as day I
should have seen. Kudos' Ralph |
#7
![]() |
|||
|
|||
![]()
glad to help
-- Don Guillett SalesAid Software "Ralphael1" wrote in message oups.com... OK, Thanks, now I think I understand something that was palin as day I should have seen. Kudos' Ralph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
i want to change dollar sign to rands on excel invoice? | Excel Discussion (Misc queries) | |||
How do I align numbers where one number has a dollar sign? | Charts and Charting in Excel | |||
dollar sign | Excel Discussion (Misc queries) | |||
Changing Dollar sign to another currency not listed in Excel | Excel Discussion (Misc queries) | |||
Align $ sign next to numbers | Excel Discussion (Misc queries) |